ALUM EMPLOYMENT Table
View exposing alumni employment records including employer, occupation, and related professional attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUM_BIOGRAPHIC_KEY |
Surrogate key identifying the alum biographic. |
VARCHAR2 |
10 |
DATA_SOURCE |
Data source as provided by the source. |
VARCHAR2 |
40 |
DATE_ADDED |
Date added as provided by the source. |
DATE |
|
DATE_MODIFIED |
Date modified as provided by the source. |
DATE |
|
EMPLOYER_ID_NUMBER |
Employer id number as provided by the source. |
VARCHAR2 |
10 |
EMPLOYER_NAME1 |
Employer name1 as provided by the source. |
VARCHAR2 |
60 |
EMPLOYER_NAME2 |
Employer name2 as provided by the source. |
VARCHAR2 |
60 |
EMPLOYER_UNIT |
Employer unit as provided by the source. |
VARCHAR2 |
60 |
EMPLOYMENT_COMMENT |
Employment comment as provided by the source. |
VARCHAR2 |
750 |
EMPLOYMENT_RELATION |
Employment relation as provided by the source. |
VARCHAR2 |
40 |
EMPLOYMENT_START_DATE |
Date associated with employment start. |
VARCHAR2 |
8 |
EMPLOYMENT_STOP_DATE |
Date associated with employment stop. |
VARCHAR2 |
8 |
FIELD_OF_SPEC1 |
Field of spec1 as provided by the source. |
VARCHAR2 |
40 |
FIELD_OF_SPEC2 |
Field of spec2 as provided by the source. |
VARCHAR2 |
40 |
FIELD_OF_SPEC3 |
Field of spec3 as provided by the source. |
VARCHAR2 |
40 |
FIELD_OF_WORK |
Field of work as provided by the source. |
VARCHAR2 |
40 |
JOB_STATUS |
Job status as provided by the source. |
VARCHAR2 |
40 |
JOB_TITLE |
Job title as provided by the source. |
VARCHAR2 |
60 |
MATCHING_STATUS_IND |
Matching status ind as provided by the source. |
VARCHAR2 |
1 |
NATURE_OF_BUSINESS |
Nature of business as provided by the source. |
VARCHAR2 |
40 |
OCCUPATIONAL_NAME |
Occupational name as provided by the source. |
VARCHAR2 |
40 |
POSITION_DESCRIPTION |
Description of position. |
VARCHAR2 |
35 |
POSITION_LEVEL |
Position level as provided by the source. |
VARCHAR2 |
40 |
PRIMARY_EMPLOYMENT_IND |
Primary employment ind as provided by the source. |
VARCHAR2 |
1 |
SELF_EMPLOYMENT_IND |
Self employment ind as provided by the source. |
VARCHAR2 |
1 |
SEQUENCE_NUMBER |
Sequence number as provided by the source. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |