RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE Operational Data Store
Composite View Target: AR_USER_DEFINED_FIELDS

Description Source composite view contains user defined fields for each aid year and person.

Target Column Business Definition Database Data Type Source Name Source Column
AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(4)

ROBUSDF

ROBUSDF_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

NA

NA

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

NA

NA

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

ROBUSDF

ROBUSDF_PIDM

USER_FIELD_1 Value stored in user-defined variable field number 1. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_1

USER_FIELD_10 Value stored in user-defined variable field number 10. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_10

USER_FIELD_11 Value stored in user-defined variable field number 11. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_11

USER_FIELD_12 Value stored in user-defined variable field number 12. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_12

USER_FIELD_13 Value stored in user-defined variable field number 13. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_13

USER_FIELD_14 Value stored in user-defined variable field number 14. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_14

USER_FIELD_15 Value stored in user-defined variable field number 15. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_15

USER_FIELD_16 Value stored in user-defined variable field number 16. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_16

USER_FIELD_17 Value stored in user-defined variable field number 17. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_17

USER_FIELD_18 Value stored in user-defined variable field number 18. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_18

USER_FIELD_19 Value stored in user-defined variable field number 19. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_19

USER_FIELD_2 Value stored in user-defined variable field number 2. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_2

USER_FIELD_20 Value stored in user-defined variable field number 20. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_20

USER_FIELD_21 Value stored in user-defined variable field number 21. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_21

USER_FIELD_22 Value stored in user-defined variable field number 22. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_22

USER_FIELD_23 Value stored in user-defined variable field number 23. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_23

USER_FIELD_24 Value stored in user-defined variable field number 24. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_24

USER_FIELD_25 Value stored in user-defined variable field number 25. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_25

USER_FIELD_26 Value stored in user-defined variable field number 26. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_26

USER_FIELD_27 Value stored in user-defined variable field number 27. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_27

USER_FIELD_28 Value stored in user-defined variable field number 28. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_28

USER_FIELD_29 Value stored in user-defined variable field number 29. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_29

USER_FIELD_3 Value stored in user-defined variable field number 3. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_3

USER_FIELD_30 Value stored in user-defined variable field number 30. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_30

USER_FIELD_31 Value stored in user-defined variable field number 31. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_31

USER_FIELD_32 Value stored in user-defined variable field number 32. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_32

USER_FIELD_33 Value stored in user-defined variable field number 33. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_33

USER_FIELD_34 Value stored in user-defined variable field number 34. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_34

USER_FIELD_35 Value stored in user-defined variable field number 35. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_35

USER_FIELD_36 Value stored in user-defined variable field number 36. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_36

USER_FIELD_37 Value stored in user-defined variable field number 37. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_37

USER_FIELD_38 Value stored in user-defined variable field number 38. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_38

USER_FIELD_39 Value stored in user-defined variable field number 39. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_39

USER_FIELD_4 Value stored in user-defined variable field number 4. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_4

USER_FIELD_40 Value stored in user-defined variable field number 40. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_40

USER_FIELD_41 Value stored in user-defined variable field number 41. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_41

USER_FIELD_42 Value stored in user-defined variable field number 42. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_42

USER_FIELD_43 Value stored in user-defined variable field number 43. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_43

USER_FIELD_44 Value stored in user-defined variable field number 44. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_44

USER_FIELD_45 Value stored in user-defined variable field number 45. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_45

USER_FIELD_46 Value stored in user-defined variable field number 46. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_46

USER_FIELD_47 Value stored in user-defined variable field number 47. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_47

USER_FIELD_48 Value stored in user-defined variable field number 48. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_48

USER_FIELD_49 Value stored in user-defined variable field number 49. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_49

USER_FIELD_5 Value stored in user-defined variable field number 5. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_5

USER_FIELD_50 Value stored in user-defined variable field number 50. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_50

USER_FIELD_51 Value stored in user-defined variable field number 51. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_51

USER_FIELD_52 Value stored in user-defined variable field number 52. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_52

USER_FIELD_53 Value stored in user-defined variable field number 53. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_53

USER_FIELD_54 Value stored in user-defined variable field number 54. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_54

USER_FIELD_55 Value stored in user-defined variable field number 55. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_55

USER_FIELD_56 Value stored in user-defined variable field number 56. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_56

USER_FIELD_57 Value stored in user-defined variable field number 57. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_57

USER_FIELD_58 Value stored in user-defined variable field number 58. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_58

USER_FIELD_59 Value stored in user-defined variable field number 59. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_59

USER_FIELD_6 Value stored in user-defined variable field number 6. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_6

USER_FIELD_60 Value stored in user-defined variable field number 60. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_60

USER_FIELD_7 Value stored in user-defined variable field number 7. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_7

USER_FIELD_8 Value stored in user-defined variable field number 8. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_8

USER_FIELD_9 Value stored in user-defined variable field number 9. VARCHAR2(20)

ROBUSDF

ROBUSDF_VALUE_9

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

NA

NA



Ver: 3.1