Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SORHSCH SORPCOL
|
SORHSCH_PIDM SORPCOL_PIDM
|
NO NO
|
NO
|
POST_SECONDARY_COLLEGE_1
|
Identifies the first college code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_COLL_CODE
|
NO
|
NO
|
POST_SECONDARY_COLLEGE_2
|
Identifies the second college code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_COLL_CODE
|
NO
|
NO
|
POST_SECONDARY_COLLEGE_3
|
Identifies the third college code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_COLL_CODE
|
NO
|
NO
|
POST_SECONDARY_COLLEGE_DESC_1
|
Identifies the description of the first college code associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_COLLEGE_DESC_2
|
Identifies the description of the second college code associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_COLLEGE_DESC_3
|
Identifies the description of the third college code associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_DEGREE_1
|
First degree code associated with prior college.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_DEGC_CODE
|
NO
|
NO
|
POST_SECONDARY_DEGREE_2
|
First degree code associated with prior college.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_DEGC_CODE
|
NO
|
NO
|
POST_SECONDARY_DEGREE_3
|
First degree code associated with prior college.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_DEGC_CODE
|
NO
|
NO
|
POST_SECONDARY_DEGREE_DATE_1
|
First degree date associated with post secondary institution.
|
DATE
|
SORDEGR
|
SORDEGR_DEGC_DATE
|
NO
|
NO
|
POST_SECONDARY_DEGREE_DATE_2
|
First degree date associated with post secondary institution.
|
DATE
|
SORDEGR
|
SORDEGR_DEGC_DATE
|
NO
|
NO
|
POST_SECONDARY_DEGREE_DATE_3
|
First degree date associated with post secondary institution.
|
DATE
|
SORDEGR
|
SORDEGR_DEGC_DATE
|
NO
|
NO
|
POST_SECONDARY_DEGREE_DESC_1
|
Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_DEGREE_DESC_2
|
Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_DEGREE_DESC_3
|
Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_DEGREE_SEQ_1
|
First degree sequence associated with post secondary institution.
|
NUMBER
|
SORDEGR
|
SORDEGR_DEGR_SEQ_NO
|
NO
|
NO
|
POST_SECONDARY_DEGREE_SEQ_2
|
First degree sequence associated with post secondary institution.
|
NUMBER
|
SORDEGR
|
SORDEGR_DEGR_SEQ_NO
|
NO
|
NO
|
POST_SECONDARY_DEGREE_SEQ_3
|
First degree sequence associated with post secondary institution.
|
NUMBER
|
SORDEGR
|
SORDEGR_DEGR_SEQ_NO
|
NO
|
NO
|
POST_SECONDARY_DEGREE_YEAR_1
|
First degree year associated with post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_DEGC_YEAR
|
NO
|
NO
|
POST_SECONDARY_DEGREE_YEAR_2
|
First degree year associated with post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_DEGC_YEAR
|
NO
|
NO
|
POST_SECONDARY_DEGREE_YEAR_3
|
First degree year associated with post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_DEGC_YEAR
|
NO
|
NO
|
POST_SECONDARY_HONORS_1
|
Identifies the first honor code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_HONR_CODE
|
NO
|
NO
|
POST_SECONDARY_HONORS_2
|
Identifies the second honor code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_HONR_CODE
|
NO
|
NO
|
POST_SECONDARY_HONORS_3
|
Identifies the third honor code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_HONR_CODE
|
NO
|
NO
|
POST_SECONDARY_HONORS_DESC_1
|
Identifies the description of the first honor code associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_HONORS_DESC_2
|
Identifies the description of the second honor code associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_HONORS_DESC_3
|
Identifies the description of the third honor code associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_MAJOR1_1
|
First major code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORMAJR
|
SORMAJR_MAJR_CODE_MAJOR
|
NO
|
NO
|
POST_SECONDARY_MAJOR1_2
|
First major code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORMAJR
|
SORMAJR_MAJR_CODE_MAJOR
|
NO
|
NO
|
POST_SECONDARY_MAJOR1_3
|
First major code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORMAJR
|
SORMAJR_MAJR_CODE_MAJOR
|
NO
|
NO
|
POST_SECONDARY_MAJOR1_DESC_1
|
First major code description associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_MAJOR1_DESC_2
|
First major code description associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_MAJOR1_DESC_3
|
First major code description associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_MAJOR2_1
|
Second major code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORMAJR
|
SORMAJR_MAJR_CODE_MAJOR
|
NO
|
NO
|
POST_SECONDARY_MAJOR2_2
|
Second major code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORMAJR
|
SORMAJR_MAJR_CODE_MAJOR
|
NO
|
NO
|
POST_SECONDARY_MAJOR2_3
|
Second major code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORMAJR
|
SORMAJR_MAJR_CODE_MAJOR
|
NO
|
NO
|
POST_SECONDARY_MAJOR2_DESC_1
|
Second major code description associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_MAJOR2_DESC_2
|
Second major code description associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_MAJOR2_DESC_3
|
Second major code description associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_MAJOR3_1
|
Third major code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORMAJR
|
SORMAJR_MAJR_CODE_MAJOR
|
NO
|
NO
|
POST_SECONDARY_MAJOR3_2
|
Third major code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORMAJR
|
SORMAJR_MAJR_CODE_MAJOR
|
NO
|
NO
|
POST_SECONDARY_MAJOR3_3
|
Third major code associated with the post secondary institution.
|
VARCHAR2(63)
|
SORMAJR
|
SORMAJR_MAJR_CODE_MAJOR
|
NO
|
NO
|
POST_SECONDARY_MAJOR3_DESC_1
|
Third major code description associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_MAJOR3_DESC_2
|
Third major code description associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_MAJOR3_DESC_3
|
Third major code description associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_SCHOOL_1
|
Source/ background institution code for the high school or prior college.
|
VARCHAR2(63)
|
SORHSCH SORPCOL
|
SORHSCH_SBGI_CODE SORPCOL_SBGI_CODE
|
NO NO
|
NO
|
POST_SECONDARY_SCHOOL_2
|
Source/ background institution code for the high school or prior college.
|
VARCHAR2(63)
|
SORHSCH SORPCOL
|
SORHSCH_SBGI_CODE SORPCOL_SBGI_CODE
|
NO NO
|
NO
|
POST_SECONDARY_SCHOOL_3
|
Source/ background institution code for the high school or prior college.
|
VARCHAR2(63)
|
SORHSCH SORPCOL
|
SORHSCH_SBGI_CODE SORPCOL_SBGI_CODE
|
NO NO
|
NO
|
POST_SECONDARY_SCHOOL_DESC_1
|
Source/background institution name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_SCHOOL_DESC_2
|
Source/background institution name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_SCHOOL_DESC_3
|
Source/background institution name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POST_SECONDARY_TRANS_CREDITS_1
|
Number of transfer credits received from the previous post secondary institution.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_CALC_TRANSFER_CREDITS
|
NO
|
NO
|
POST_SECONDARY_TRANS_CREDITS_2
|
Number of transfer credits received from the previous post secondary institution.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_CALC_TRANSFER_CREDITS
|
NO
|
NO
|
POST_SECONDARY_TRANS_CREDITS_3
|
Number of transfer credits received from the previous post secondary institution.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_CALC_TRANSFER_CREDITS
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIF1_DESC_1
|
Classification of Institutional Programs (CIP) code for the first major code associated with the post secondary institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIF1_DESC_2
|
Classification of Institutional Programs (CIP) code for the first major code associated with the post secondary institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIF1_DESC_3
|
Classification of Institutional Programs (CIP) code for the first major code associated with the post secondary institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIF2_DESC_1
|
Classification of Institutional Programs (CIP) code for the second major code associated with the post secondary institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIF2_DESC_2
|
Classification of Institutional Programs (CIP) code for the second major code associated with the post secondary institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIF2_DESC_3
|
Classification of Institutional Programs (CIP) code for the second major code associated with the post secondary institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIF3_DESC_1
|
Classification of Institutional Programs (CIP) code description for the third major code associated with the post secondary institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIF3_DESC_2
|
Classification of Institutional Programs (CIP) code description for the third major code associated with the post secondary institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIF3_DESC_3
|
Classification of Institutional Programs (CIP) code description for the third major code associated with the post secondary institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIFICATION1_1
|
Classification of Institutional Programs (CIP) code of the first major code associated with the post secondary institution.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIFICATION1_2
|
Classification of Institutional Programs (CIP) code of the first major code associated with the post secondary institution.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIFICATION1_3
|
Classification of Institutional Programs (CIP) code of the first major code associated with the post secondary institution.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIFICATION2_1
|
Classification of Institutional Programs (CIP) code of the second major code associated with the post secondary institution.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIFICATION2_2
|
Classification of Institutional Programs (CIP) code of the second major code associated with the post secondary institution.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIFICATION2_3
|
Classification of Institutional Programs (CIP) code of the second major code associated with the post secondary institution.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIFICATION3_1
|
Classification of Institutional Programs (CIP) code of the third major code associated with the post secondary institution.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIFICATION3_2
|
Classification of Institutional Programs (CIP) code of the third major code associated with the post secondary institution.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM_CLASSIFICATION3_3
|
Classification of Institutional Programs (CIP) code of the third major code associated with the post secondary institution.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PS_ATTEND_FROM_DATE_1
|
Previous education first date of attendance.
|
DATE
|
SORDEGR
|
SORDEGR_ATTEND_FROM
|
NO
|
NO
|
PS_ATTEND_FROM_DATE_2
|
Previous education first date of attendance.
|
DATE
|
SORDEGR
|
SORDEGR_ATTEND_FROM
|
NO
|
NO
|
PS_ATTEND_FROM_DATE_3
|
Previous education first date of attendance.
|
DATE
|
SORDEGR
|
SORDEGR_ATTEND_FROM
|
NO
|
NO
|
PS_ATTEND_TO_DATE_1
|
Previous education last date of attendance.
|
DATE
|
SORDEGR
|
SORDEGR_ATTEND_TO
|
NO
|
NO
|
PS_ATTEND_TO_DATE_2
|
Previous education last date of attendance.
|
DATE
|
SORDEGR
|
SORDEGR_ATTEND_TO
|
NO
|
NO
|
PS_ATTEND_TO_DATE_3
|
Previous education last date of attendance.
|
DATE
|
SORDEGR
|
SORDEGR_ATTEND_TO
|
NO
|
NO
|
PS_AWARD_CATEGORY_1
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
NO
|
NO
|
PS_AWARD_CATEGORY_2
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
NO
|
NO
|
PS_AWARD_CATEGORY_3
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
NO
|
NO
|
PS_AWARD_CATEGORY_DESC_1
|
Description of the award category.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PS_AWARD_CATEGORY_DESC_2
|
Description of the award category.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PS_AWARD_CATEGORY_DESC_3
|
Description of the award category.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PS_EDUCATION_GOAL_1
|
Identifies the first education goal associated with the post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_EGOL_CODE
|
NO
|
NO
|
PS_EDUCATION_GOAL_2
|
Identifies the second education goal associated with the post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_EGOL_CODE
|
NO
|
NO
|
PS_EDUCATION_GOAL_3
|
Identifies the third education goal associated with the post secondary institution.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_EGOL_CODE
|
NO
|
NO
|
PS_EDUCATION_GOAL_DESC_1
|
Identifies the description of the first education goal associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PS_EDUCATION_GOAL_DESC_2
|
Identifies the description of the second education goal associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PS_EDUCATION_GOAL_DESC_3
|
Identifies the description of the third education goal associated with the post secondary institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PS_OFFICIAL_TRANSCRIPT_IND_1
|
Indicates whether the transcript was an official transcript.
|
VARCHAR2(1)
|
SORPCOL
|
SORPCOL_OFFICIAL_TRANS
|
NO
|
NO
|
PS_OFFICIAL_TRANSCRIPT_IND_2
|
Indicates whether the transcript was an official transcript.
|
VARCHAR2(1)
|
SORPCOL
|
SORPCOL_OFFICIAL_TRANS
|
NO
|
NO
|
PS_OFFICIAL_TRANSCRIPT_IND_3
|
Indicates whether the transcript was an official transcript.
|
VARCHAR2(1)
|
SORPCOL
|
SORPCOL_OFFICIAL_TRANS
|
NO
|
NO
|
PS_SCHOOL_GPA_1
|
Person's post secondary institution average or GPA.
|
VARCHAR2(63)
|
SORDEGR SORHSCH
|
SORDEGR_GPA_TRANSFERRED SORHSCH_GPA
|
NO NO
|
NO
|
PS_SCHOOL_GPA_2
|
Person's post secondary institution average or GPA.
|
VARCHAR2(63)
|
SORDEGR SORHSCH
|
SORDEGR_GPA_TRANSFERRED SORHSCH_GPA
|
NO NO
|
NO
|
PS_SCHOOL_GPA_3
|
Person's post secondary institution average or GPA.
|
VARCHAR2(63)
|
SORDEGR SORHSCH
|
SORDEGR_GPA_TRANSFERRED SORHSCH_GPA
|
NO NO
|
NO
|
PS_SCHOOL_PERCENTILE_1
|
Person's class percentile as related to class rank and size.
|
NUMBER
|
SORHSCH
|
SORHSCH_PERCENTILE
|
NO
|
NO
|
PS_SCHOOL_PERCENTILE_2
|
Person's class percentile as related to class rank and size.
|
NUMBER
|
SORHSCH
|
SORHSCH_PERCENTILE
|
NO
|
NO
|
PS_SCHOOL_PERCENTILE_3
|
Person's class percentile as related to class rank and size.
|
NUMBER
|
SORHSCH
|
SORHSCH_PERCENTILE
|
NO
|
NO
|
PS_SCHOOL_RANK_1
|
Person's institution class rank.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_RANK
|
NO
|
NO
|
PS_SCHOOL_RANK_2
|
Person's institution class rank.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_RANK
|
NO
|
NO
|
PS_SCHOOL_RANK_3
|
Person's institution class rank.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_RANK
|
NO
|
NO
|
PS_SCHOOL_SIZE_1
|
Size of the person's institution graduating class.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_SIZE
|
NO
|
NO
|
PS_SCHOOL_SIZE_2
|
Size of the person's institution graduating class.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_SIZE
|
NO
|
NO
|
PS_SCHOOL_SIZE_3
|
Size of the person's institution graduating class.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_SIZE
|
NO
|
NO
|
PS_TRANSCRIPT_RECEIVED_DATE_1
|
Date an academic transcript was received.
|
DATE
|
SORHSCH SORPCOL
|
SORHSCH_TRANS_RECV_DATE SORPCOL_TRANS_RECV_DATE
|
NO NO
|
NO
|
PS_TRANSCRIPT_RECEIVED_DATE_2
|
Date an academic transcript was received.
|
DATE
|
SORHSCH SORPCOL
|
SORHSCH_TRANS_RECV_DATE SORPCOL_TRANS_RECV_DATE
|
NO NO
|
NO
|
PS_TRANSCRIPT_RECEIVED_DATE_3
|
Date an academic transcript was received.
|
DATE
|
SORHSCH SORPCOL
|
SORHSCH_TRANS_RECV_DATE SORPCOL_TRANS_RECV_DATE
|
NO NO
|
NO
|
PS_TRANSCRIPT_REVIEWED_DATE_1
|
Date the academic transcript was reviewed.
|
DATE
|
SORPCOL
|
SORPCOL_TRANS_REV_DATE
|
NO
|
NO
|
PS_TRANSCRIPT_REVIEWED_DATE_2
|
Date the academic transcript was reviewed.
|
DATE
|
SORPCOL
|
SORPCOL_TRANS_REV_DATE
|
NO
|
NO
|
PS_TRANSCRIPT_REVIEWED_DATE_3
|
Date the academic transcript was reviewed.
|
DATE
|
SORPCOL
|
SORPCOL_TRANS_REV_DATE
|
NO
|
NO
|
SECONDARY_SCHOOL
|
Source/ background institution code for the high school or prior college.
|
VARCHAR2(63)
|
SORHSCH SORPCOL
|
SORHSCH_SBGI_CODE SORPCOL_SBGI_CODE
|
NO NO
|
NO
|
SECONDARY_SCHOOL_NAME
|
Source/background institution name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SS_ATTEND_FROM_DATE
|
Previous education first date of attendance.
|
DATE
|
SORDEGR
|
SORDEGR_ATTEND_FROM
|
NO
|
NO
|
SS_ATTEND_TO_DATE
|
Previous education last date of attendance.
|
DATE
|
SORDEGR
|
SORDEGR_ATTEND_TO
|
NO
|
NO
|
SS_DIPLOMA
|
Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc.
|
VARCHAR2(63)
|
SORHSCH
|
SORHSCH_DPLM_CODE
|
NO
|
NO
|
SS_DIPLOMA_DESC
|
Secondary school diploma description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SS_GRAD_DATE
|
Person's graduation date from the secondary institution.
|
DATE
|
SORHSCH
|
SORHSCH_GRADUATION_DATE
|
NO
|
NO
|
SS_OFFICIAL_TRANSCRIPT_IND
|
Indicates whether the transcript was an official transcript.
|
VARCHAR2(1)
|
SORPCOL
|
SORPCOL_OFFICIAL_TRANS
|
NO
|
NO
|
SS_PERCENTILE
|
Person's class percentile as related to class rank and size.
|
NUMBER
|
SORHSCH
|
SORHSCH_PERCENTILE
|
NO
|
NO
|
SS_SCHOOL_GPA
|
Person's post secondary institution average or GPA.
|
VARCHAR2(63)
|
SORDEGR SORHSCH
|
SORDEGR_GPA_TRANSFERRED SORHSCH_GPA
|
NO NO
|
NO
|
SS_SCHOOL_RANK
|
Person's institution class rank.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_RANK
|
NO
|
NO
|
SS_SCHOOL_SIZE
|
Size of the person's institution graduating class.
|
NUMBER
|
SORHSCH
|
SORHSCH_CLASS_SIZE
|
NO
|
NO
|
SS_TRANSCRIPT_RECEIVED_DATE
|
Date an academic transcript was received.
|
DATE
|
SORHSCH SORPCOL
|
SORHSCH_TRANS_RECV_DATE SORPCOL_TRANS_RECV_DATE
|
NO NO
|
NO
|
SS_TRANSCRIPT_REVIEWED_DATE
|
Date an academic transcript was reviewed by the institution.
|
DATE
|
SORPCOL
|
SORPCOL_TRANS_REV_DATE
|
NO
|
NO
|