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