ALUM EMPLOYMENT Table
This table contains MIT alumni's employment records
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUM_BIOGRAPHIC_KEY |
Use this field to join together the ALUM_BIOGRAPHIC table to another Alumni fact table with this field to get specific information about a person. |
VARCHAR2 |
10 |
DATA_SOURCE |
Source of the data in this record. |
VARCHAR2 |
40 |
DATE_ADDED |
Date the record was added to the table. |
DATE |
8 |
DATE_MODIFIED |
Date the record in the table was last modified. |
DATE |
8 |
EMPLOYER_ID_NUMBER |
ID number assigned to the employer in this employment record. |
VARCHAR2 |
10 |
EMPLOYER_NAME1 |
Name of employer. |
VARCHAR2 |
60 |
EMPLOYER_NAME2 |
Name of employer. |
VARCHAR2 |
60 |
EMPLOYER_UNIT |
Unit or Department, eg. Department of Physics, Music and Theater Arts Section, Product Development. |
VARCHAR2 |
60 |
EMPLOYMENT_COMMENT |
Comments/notes about the employment. |
VARCHAR2 |
255 |
EMPLOYMENT_RELATION |
Values in this field include: Fomer Employer, Owner, Partner, Consultant, Board Member, Primary Employer, volunteer, Part-Time Employer, Spouse's Employer. |
VARCHAR2 |
40 |
EMPLOYMENT_START_DATE |
Date when this employment starts. |
VARCHAR2 |
8 |
EMPLOYMENT_STOP_DATE |
Date when this employment ends. |
VARCHAR2 |
8 |
FIELD_OF_SPEC1 |
Field of Specialty |
VARCHAR2 |
40 |
FIELD_OF_SPEC2 |
Field of Specialty |
VARCHAR2 |
40 |
FIELD_OF_SPEC3 |
Field of Specialty |
VARCHAR2 |
40 |
FIELD_OF_WORK |
XXX |
VARCHAR2 |
40 |
JOB_STATUS |
In the ALUM_EMPLOYMENT table, this field contains the current status of the employment: Active, Past, Temporary, Retired, etc. |
VARCHAR2 |
40 |
JOB_TITLE |
In MIT's HR tables this field contains the official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office. |
VARCHAR2 |
50 |
MATCHING_STATUS_IND |
XXX |
VARCHAR2 |
1 |
NATURE_OF_BUSINESS |
In the ALUM_EMPLOYMENT table, this keeps the "nature of business" of the employment, eg. Law, Pharmaceutical, Management Consultant, Communications, Retail, Banking, etc. |
VARCHAR2 |
40 |
OCCUPATIONAL_NAME |
Occupational name for this employment. Eg. Physician, Attorney, Calligraphier/Designer, Statistician, Scientist, Lecturer. |
VARCHAR2 |
40 |
POSITION_DESCRIPTION |
Description of the position. |
VARCHAR2 |
35 |
POSITION_LEVEL |
Level of position. |
VARCHAR2 |
40 |
PRIMARY_EMPLOYMENT_IND |
A value of 'Y' indicates that this is a primary employment. |
VARCHAR2 |
1 |
SELF_EMPLOYMENT_IND |
A value of 'Y' indicats that this is a self employment. |
VARCHAR2 |
1 |
SEQUENCE_NUMBER |
Numerical value identifying the position of this record for the person. |
NUMBER |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |