Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
FIRST_CONTACT
|
Type of the earliest contact of the pre-student.
|
VARCHAR2(3)
|
SORCONT
|
SORCONT_CTYP_CODE
|
NO
|
NO
|
FIRST_CONTACT_DATE
|
First contact of the pre-student by date.
|
DATE
|
SORCONT
|
SORCONT_CONTACT_DATE
|
NO
|
NO
|
FIRST_CONTACT_DESC
|
First contact description.
|
VARCHAR2(30)
|
STVCTYP
|
STVCTYP_DESC
|
NO
|
NO
|
LATEST_CONTACT
|
Type of last contact that has been made with the pre-student.
|
VARCHAR2(3)
|
SORCONT
|
SORCONT_CTYP_CODE
|
NO
|
NO
|
LATEST_CONTACT_DATE
|
Date of the last contact of the pre-student.
|
DATE
|
SORCONT
|
SORCONT_CONTACT_DATE
|
NO
|
NO
|
LATEST_CONTACT_DESC
|
Last contact description.
|
VARCHAR2(30)
|
STVCTYP
|
STVCTYP_DESC
|
NO
|
NO
|
LATEST_POST_SECONDARY_DESC
|
Source/background institution name.
|
VARCHAR2(30)
|
STVSBGI
|
STVSBGI_DESC
|
NO
|
NO
|
LATEST_POST_SECONDARY_SCHOOL
|
Most recent post secondary institution code for the recruit/applicant.
|
VARCHAR2(6)
|
FUNCTION
|
SOKODSF.F_SORPCOL_INFO
|
NO
|
NO
|
LATEST_SECONDARY_SCHOOL
|
Most recent secondary school of the prospect/applicant identified by graduation date.
|
VARCHAR2(6)
|
SORHSCH
|
SORHSCH_SBGI_CODE
|
NO
|
NO
|
LATEST_SECONDARY_SCHOOL_DESC
|
Source/background institution name.
|
VARCHAR2(30)
|
STVSBGI
|
STVSBGI_DESC
|
NO
|
NO
|
LATEST_SEC_ATTEND_FROM_DATE
|
First date of attendance at the most recent secondary institution.
|
DATE
|
NA
|
NA
|
NO
|
NO
|
LATEST_SEC_ATTEND_TO_DATE
|
Last date of attendance at the most recent secondary institution.
|
DATE
|
NA
|
NA
|
NO
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SARADAP SRBRECR
|
SARADAP_PIDM SRBRECR_PIDM
|
NO NO
|
NO
|
PS_ATTEND_FROM_DATE
|
First date of attendance at the post secondary institution.
|
DATE
|
FUNCTION
|
SOKODSF.F_SORPCOL_INFO
|
NO
|
NO
|
PS_ATTEND_TO_DATE
|
Last date of attendance at the post secondary institution.
|
DATE
|
FUNCTION
|
SOKODSF.F_SORPCOL_INFO
|
NO
|
NO
|
PS_GPA_TRANSFERRED
|
Transfer GPA. Informational data given on the student application about the post secondary institution listed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_SORPCOL_INFO
|
NO
|
NO
|
PS_OFFICIAL_TRANSCRIPT_IND
|
Indicates whether the post secondary institution transcript was an official transcript.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
PS_SCHOOL_PERCENTILE
|
Prospect/applicant's class percentile as related to class rank and size at the previous institution.
|
NUMBER
|
NA
|
NA
|
NO
|
NO
|
PS_SCHOOL_RANK
|
Prospect/applicant's previous institution class rank.
|
NUMBER
|
NA
|
NA
|
NO
|
NO
|
PS_SCHOOL_SIZE
|
Size of the prospect/applicant's previous institution graduating class.
|
NUMBER
|
NA
|
NA
|
NO
|
NO
|
PS_TRANSCRIPT_RECEIVED_DATE
|
Date the academic transcript was received from the post secondary institution.
|
DATE
|
FUNCTION
|
SOKODSF.F_SORPCOL_INFO
|
NO
|
NO
|
PS_TRANSCRIPT_REVIEWED_DATE
|
Date the academic transcript was received from the post secondary institution.
|
DATE
|
FUNCTION
|
SOKODSF.F_SORPCOL_INFO
|
NO
|
NO
|
SECONDARY_SCHOOL_DIPLOMA
|
Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc.
|
VARCHAR2(2)
|
SORHSCH
|
SORHSCH_DPLM_CODE
|
NO
|
NO
|
SECONDARY_SCHOOL_DIPLOMA_DESC
|
Secondary school diploma description.
|
VARCHAR2(30)
|
STVDPLM
|
STVDPLM_DESC
|
NO
|
NO
|
SECONDARY_SCHOOL_GRAD_DATE
|
Person's graduation date from the secondary institution.
|
DATE
|
SORHSCH
|
SORHSCH_GRADUATION_DATE
|
NO
|
NO
|
SECONDARY_SCHOOL_PERCENTILE
|
Person's class percentile as related to class rank and size.
|
NUMBER
|
SORHSCH
|
SORHSCH_PERCENTILE
|
NO
|
NO
|
SECONDARY_SCHOOL_RANK
|
Person's institution class rank.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_RANK
|
NO
|
NO
|
SECONDARY_SCHOOL_REPORTED_GPA
|
Person's secondary institution average or GPA.
|
VARCHAR2(24)
|
SORHSCH
|
SORHSCH_GPA
|
NO
|
NO
|
SECONDARY_SCHOOL_SIZE
|
Size of the person's institution graduating class.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_SIZE
|
NO
|
NO
|
SEC_OFFICIAL_TRANSCRIPT_IND
|
Indicates whether the most recent secondary institution transcript was an official transcript.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
SEC_TRANSCRIPT_RECEIVED_DATE
|
Date an secondary school academic transcript was received.
|
DATE
|
SORHSCH
|
SORHSCH_TRANS_RECV_DATE
|
NO
|
NO
|
SEC_TRANSCRIPT_REVIEWED_DATE
|
Date an academic transcript was reviewed by the institution.
|
DATE
|
NA
|
NA
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|