Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_PREVIOUS_EDUCATION_PCOL

Description Source composite view contains information on post secondary institutions the person attended.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ATTEND_FROM_DATE Attend From Date Previous education first date of attendance. DATE  

SHRTRAM

SHRTRAM_ATTN_BEGIN_DATE

ATTEND_TO_DATE Attend To Date Previous education last date of attendance. DATE  

SHRTRAM

SHRTRAM_ATTN_END_DATE

AWARD_CATEGORY 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(2)  

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC   Award category description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE College Identifies the college code associated with the post secondary institution. VARCHAR2(2)  

SORDEGR

SORDEGR_COLL_CODE

COLLEGE_DESC College Description Identifies the college code description associated with the post secondary institution. VARCHAR2(30)  

STVCOLL

STVCOLL_DESC

COLLEGE_PREP   This field indicates whether the prospect/applicant high school program was college prep. VARCHAR2(1)  

NA

NA

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

EDUCATION_ACTIVITY_DATE Education Activity Date Identifies the last date this record was created or updated. DATE  

SHRTRAM

SHRTRIT

SORPCOL

SHRTRAM_ACTIVITY_DATE

SHRTRIT_ACTIVITY_DATE

SORPCOL_ACTIVITY_DATE

EDUCATION_DATA_ORIGIN Education Data Origin   VARCHAR2(30)      
EDUCATION_GOAL Education Goal Recorded education goal from the secondary or post secondary institution. VARCHAR2(2)  

SORDEGR

SORDEGR_EGOL_CODE

EDUCATION_GOAL_DESC Education Goal Description Educational goal description. VARCHAR2(30)  

STVEGOL

STVEGOL_DESC

EDUCATION_USER_ID Education User ID   VARCHAR2(30)      
INSTITUTION Institution Source/background institution code for the prior college. VARCHAR2(6)  

SHRTRIT

SHRTRIT_SBGI_CODE

INSTITUTION_DESC   Source/background institution name. VARCHAR2(30)  

STVSBGI

STVSBGI_DESC

INSTITUTION_TYPE   Identifies a type for the source/background institution to be used for reporting. VARCHAR2(1)  

STVSBGI

STVSBGI_TYPE_IND

INSTITUTION_TYPE_DESC   This field specifies the source/background institution type. VARCHAR2(30)  

CONSTANT

'COLLEGE'

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

OFFICIAL_TRANSCRIPT_IND Official Transcript Indicator Indicates whether the transcript was an official transcript. VARCHAR2(1)  

SHRTRIT

SHRTRIT_OFFICIAL_TRANS_IND

PERCENTILE   Person's class percentile as related to class rank and size. NUMBER  

NA

NA

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

SHRTRIT

SHRTRIT_PIDM

POST_SECONDARY_DEGREE Post Secondary Degree First degree code associated with prior college. VARCHAR2(6)  

SHRTRAM

SHRTRAM_DEGC_CODE

POST_SECONDARY_DEGREE_DATE   First degree date associated with post secondary institution. DATE  

SORDEGR

SORDEGR_DEGC_DATE

POST_SECONDARY_DEGREE_DESC   Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code. VARCHAR2(30)  

STVDEGC

STVDEGC_DESC

POST_SECONDARY_DEGREE_SEQUENCE   First degree sequence associated with post secondary institution. NUMBER(2)  

SORDEGR

SORDEGR_DEGR_SEQ_NO

POST_SECONDARY_DEGREE_YEAR   First degree year associated with post secondary institution. VARCHAR2(4)  

SORDEGR

SORDEGR_DEGC_YEAR

POST_SECONDARY_HONORS Post Secondary Honors Previous institution award honors earned and recorded for the person. VARCHAR2(6)  

SORDEGR

SORDEGR_HONR_CODE

POST_SECONDARY_HONORS_DESC Post Secondary Honors Description Previous institution honors description. VARCHAR2(30)  

STVHONR

STVHONR_DESC

POST_SECONDARY_MAJOR1   First major code associated with the post secondary institution. VARCHAR2(4)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR2   Second major code associated with the post secondary institution. VARCHAR2(4)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR3   Third major code associated with the post secondary institution. VARCHAR2(4)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR_DESC1   First major code description associated with the post secondary institution. VARCHAR2(30)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR_DESC2   Second major code description associated with the post secondary institution. VARCHAR2(30)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR_DESC3   Third major code description associated with the post secondary institution. VARCHAR2(30)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION1   Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(6)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION2   Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(6)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION3   Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(6)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION_DESC1 Program Classification Description 1 Program classification description. VARCHAR2(80)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION_DESC2 Program Classification Description 2 Program classification description. VARCHAR2(80)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION_DESC3 Program Classification Description 3 Program classification description. VARCHAR2(80)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

REQUIREMENT Requirement   VARCHAR2(4)      
REQUIREMENT_DESC Requirement Description   VARCHAR2(30)      
SCHOOL_GPA   Person's post secondary institution average or GPA. VARCHAR2(40)  

SORDEGR

SORDEGR_GPA_TRANSFERRED

SCHOOL_RANK   Person's institution class rank. NUMBER  

NA

NA

SCHOOL_SIZE   Size of the person's institution graduating class. NUMBER  

NA

NA

SECONDARY_DIPLOMA   This field indicates the persons most secondary institution diploma type, i.e., college prep. VARCHAR2(6)  

NA

NA

SECONDARY_DIPLOMA_DESC   This field specifies the diploma type (e.g. college preparatory, general education) associated with the diploma type code. VARCHAR2(30)  

NA

NA

SECONDARY_SCHOOL_GRAD_DATE   Not a valid column for any post secondary school input to the ODS tables. DATE  

NA

NA

SEQUENCE_NUMBER Sequence Number Sequence number of the attendance period from the transfer institution. NUMBER  

SHRTRAM

SHRTRAM_SEQ_NO

SOURCE_FLAG Source Flag Identifies which source view this records comes from, P for AS_PREVIOUS_EDUCATION_PCOL and H for AS_PREVIOUS_EDUCATION_HSCH. It is used in relation to the OWB mappings. VARCHAR2(1)  

CONSTANT

'P'

TOTAL_TRANSFER_CREDITS   Number of transfer credits received from the previous post secondary institution. NUMBER  

FUNCTION

SOKODSF.F_CALC_TRANSFER_CREDITS

TRANSCRIPT_RECEIVED_DATE Transcript Received Date Date an academic transcript was received. DATE  

SHRTRIT

SHRTRIT_TRANS_DATE_RCVD

TRANSCRIPT_REVIEWED_DATE Transcript Reviewed Date Date an academic transcript was reviewed by the institution. DATE  

CALCULATION

NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE)

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

NA

NA



Ver: