RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE Operational Data Store
Composite View Target: AA_PREVIOUS_EMPLOYMENT

Description Source composite view contains prior employment information for any person as stored in the advancement system.

Target Column Business Definition Database Data Type Source Name Source Column
ADDRESS_TYPE_DESC Address type description. 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

EMPLOYEE_ADDRESS_SEQ_NUMBER Sequence used to identify different addresses within the same address type. NUMBER(2)

APREHIS

APREHIS_ATYP_SEQNO

EMPLOYEE_ADDRESS_TYPE Type of address for this address record. Examples, may be address types of mailing, temporary summer, billing and permanent. VARCHAR2(2)

APREHIS

APREHIS_ATYP_CODE

EMPLOYER_CATEGORY Identifies the employer type (for example, Higher Education, Government, Commercial). VARCHAR2(3)

APREHIS

APREHIS_JOBC_CODE

EMPLOYER_CATEGORY2 A code identifying the job category or employer type. VARCHAR2(3)

APREHIS

APREHIS_JOBC_CODE2

EMPLOYER_CATEGORY2_DESC Employer category description. VARCHAR2(30)    
EMPLOYER_CATEGORY3 A code identifying the job category or employer type. VARCHAR2(3)

APREHIS

APREHIS_JOBC_CODE3

EMPLOYER_CATEGORY3_DESC Employer category description. VARCHAR2(30)    
EMPLOYER_CATEGORY4 A code identifying the job category or employer type. VARCHAR2(3)

APREHIS

APREHIS_JOBC_CODE4

EMPLOYER_CATEGORY4_DESC Employer category description. VARCHAR2(30)    
EMPLOYER_CATEGORY_DESC Employer category description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_COMMENT Free form text comment for this employer. VARCHAR2(4000)

FUNCTION

GOKODSF.F_TRIM_LONGS

EMPLOYER_INDUSTRIAL_DESC Standard industry code (sic) description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_INDUSTRIAL_TYPE Standard industrial code of the employer. VARCHAR2(4)

AOBORGN

APREHIS

AOBORGN_SICC_CODE

APREHIS_SICC_CODE

EMPLOYER_NAME The name of the previous or current employer at which this experience was obtained. VARCHAR2(60)

APREHIS

APREHIS_EMPR_NAME

EMPLOYER_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER(8)

APREHIS

APREHIS_EMPR_PIDM

EMPLOYMENT_ORDER Internal sequence number when available for the order of the positions. NUMBER(5)

APREHIS

APREHIS_SEQ_NO

EMPLOYMENT_STATUS Employment status code. VARCHAR2(1)

APREHIS

APREHIS_EMPS_CODE

EMPLOYMENT_STATUS_ACTIVE_IND Status active indicator. VARCHAR2(1)

CALCULATION

NVL(ATVEMPS_ACTIVE_IND,'N')

EMPLOYMENT_STATUS_DESC Employment status code description. VARCHAR2(30)

ATVEMPS

ATVEMPS_DESC

END_DATE End date for the period of time during which this experience was obtained. DATE

APREHIS

APREHIS_TO_DATE

MATCHING_GIFT_IND Whether a related reference has a matching gift associated with it. VARCHAR2(1)    
MIF_DESC Institution description for the record 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

MONTHS_IN_POSITION Years and months the person was in this previous employment position. Calculated by using the position start and end dates. NUMBER

CALCULATION

MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)

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

APREHIS

APREHIS_PIDM

POSITION_TITLE Title of the position occupied while obtain this experience. VARCHAR2(60)

APREHIS

APREHIS_EMPL_POSITION

PRIMARY_EMPLOYMENT_IND Indicates whether the record is the primary employment record. VARCHAR2(1)

CALCULATION

NVL(APREHIS_PRIMARY_IND,'N')

START_DATE Starting date of the period of time during which this experience was obtained. DATE

APREHIS

APREHIS_FROM_DATE

WEEKLY_HOURS Hours per week for parttime employee used for matching gift qualification. NUMBER(5, 2)

APREHIS

APREHIS_WKLY_HOURS

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