RETURN TO REPORTING VIEW REPORTS LIST
Financial Aid Reporting View Reports

SGHE Operational Data Store
Reporting View Target: USER_DEFINED_FIELDS

Description Contains the data from the financial aid user-defined fields that may be populated by aid year for the person.
Key & Frequency One row per aid year per person.
Recommended Search Columns AID_YEAR, PERSON_UID
PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)

ROBUSDF

ROBUSDF_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ID Person's or organization's current identification number. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

ROBUSDF

ROBUSDF_PIDM

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

USER_FIELD_1 Institution defined value stored in user-defined variable field number 1. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_1

USER_FIELD_10 Institution defined value stored in user-defined variable field number 10. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_10

USER_FIELD_11 Institution defined value stored in user-defined variable field number 11. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_11

USER_FIELD_12 Institution defined value stored in user-defined variable field number 12. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_12

USER_FIELD_13 Institution defined value stored in user-defined variable field number 13. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_13

USER_FIELD_14 Institution defined value stored in user-defined variable field number 14. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_14

USER_FIELD_15 Institution defined value stored in user-defined variable field number 15. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_15

USER_FIELD_16 Institution defined value stored in user-defined variable field number 16. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_16

USER_FIELD_17 Institution defined value stored in user-defined variable field number 17. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_17

USER_FIELD_18 Institution defined value stored in user-defined variable field number 18. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_18

USER_FIELD_19 Institution defined value stored in user-defined variable field number 19. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_19

USER_FIELD_2 Institution defined value stored in user-defined variable field number 2. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_2

USER_FIELD_20 Institution defined value stored in user-defined variable field number 20. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_20

USER_FIELD_21 Institution defined value stored in user-defined variable field number 21. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_21

USER_FIELD_22 Institution defined value stored in user-defined variable field number 22. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_22

USER_FIELD_23 Institution defined value stored in user-defined variable field number 23. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_23

USER_FIELD_24 Institution defined value stored in user-defined variable field number 24. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_24

USER_FIELD_25 Institution defined value stored in user-defined variable field number 25. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_25

USER_FIELD_26 Institution defined value stored in user-defined variable field number 26. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_26

USER_FIELD_27 Institution defined value stored in user-defined variable field number 27. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_27

USER_FIELD_28 Institution defined value stored in user-defined variable field number 28. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_28

USER_FIELD_29 Institution defined value stored in user-defined variable field number 29. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_29

USER_FIELD_3 Institution defined value stored in user-defined variable field number 3. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_3

USER_FIELD_30 Institution defined value stored in user-defined variable field number 30. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_30

USER_FIELD_31 Institution defined value stored in user-defined variable field number 31. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_31

USER_FIELD_32 Institution defined value stored in user-defined variable field number 32. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_32

USER_FIELD_33 Institution defined value stored in user-defined variable field number 33. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_33

USER_FIELD_34 Institution defined value stored in user-defined variable field number 34. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_34

USER_FIELD_35 Institution defined value stored in user-defined variable field number 35. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_35

USER_FIELD_36 Institution defined value stored in user-defined variable field number 36. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_36

USER_FIELD_37 Institution defined value stored in user-defined variable field number 37. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_37

USER_FIELD_38 Institution defined value stored in user-defined variable field number 38. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_38

USER_FIELD_39 Institution defined value stored in user-defined variable field number 39. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_39

USER_FIELD_4 Institution defined value stored in user-defined variable field number 4. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_4

USER_FIELD_40 Institution defined value stored in user-defined variable field number 40. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_40

USER_FIELD_41 Institution defined value stored in user-defined variable field number 41. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_41

USER_FIELD_42 Institution defined value stored in user-defined variable field number 42. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_42

USER_FIELD_43 Institution defined value stored in user-defined variable field number 43. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_43

USER_FIELD_44 Institution defined value stored in user-defined variable field number 44. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_44

USER_FIELD_45 Institution defined value stored in user-defined variable field number 45. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_45

USER_FIELD_46 Institution defined value stored in user-defined variable field number 46. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_46

USER_FIELD_47 Institution defined value stored in user-defined variable field number 47. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_47

USER_FIELD_48 Institution defined value stored in user-defined variable field number 48. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_48

USER_FIELD_49 Institution defined value stored in user-defined variable field number 49. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_49

USER_FIELD_5 Institution defined value stored in user-defined variable field number 5. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_5

USER_FIELD_50 Institution defined value stored in user-defined variable field number 50. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_50

USER_FIELD_51 Institution defined value stored in user-defined variable field number 51. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_51

USER_FIELD_52 Institution defined value stored in user-defined variable field number 52. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_52

USER_FIELD_53 Institution defined value stored in user-defined variable field number 53. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_53

USER_FIELD_54 Institution defined value stored in user-defined variable field number 54. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_54

USER_FIELD_55 Institution defined value stored in user-defined variable field number 55. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_55

USER_FIELD_56 Institution defined value stored in user-defined variable field number 56. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_56

USER_FIELD_57 Institution defined value stored in user-defined variable field number 57. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_57

USER_FIELD_58 Institution defined value stored in user-defined variable field number 58. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_58

USER_FIELD_59 Institution defined value stored in user-defined variable field number 59. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_59

USER_FIELD_6 Institution defined value stored in user-defined variable field number 6. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_6

USER_FIELD_60 Institution defined value stored in user-defined variable field number 60. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_60

USER_FIELD_7 Institution defined value stored in user-defined variable field number 7. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_7

USER_FIELD_8 Institution defined value stored in user-defined variable field number 8. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_8

USER_FIELD_9 Institution defined value stored in user-defined variable field number 9. VARCHAR2(63)

ROBUSDF

ROBUSDF_VALUE_9



Ver: 3.1