!!!Alias: EPS (P2K_HR_PERSONALS) Unique Keys: \\ Child Table: \\ Parent Table: \\ \\ Holds all date sensitive information on any given !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[EID_ID]|Number(10)|[ID]|Y|link to [P2K_HR_IDENTITIES] |[EFFECTIVE]|Date()|[EFFECTIVE]|Y| |[DSP_ID_ADDRESS]|Number(10)|[ID]|Y|link to [P2K_CM_STATE_PROVINCES] |[DCO_ID]|Number(10)|[ID]| |Citizenship link to [P2K_CM_COUNTRIES] |[DCR_ID]|Number(10)|[ID]| |link to [P2K_CM_CHANGE_REASONS] |[DSD_ID]|Number(10)|[ID]| |link to [P2K_CM_SCHOOL_DISTRICTS] |[DSP_ID_MAIL]|Number(10)|[ID]| |link to [P2K_CM_STATE_PROVINCES] |[DTX_ID]|Number(10)|[ID]| |link to [P2K_CM_TAX_JURISDICTIONS] |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[EXPIRY]|Date()|[EXPIRY]|Y| |[ADDRESS_LINE_1]|Varchar2(50)|[ADDRESS]| | |[ADDRESS_LINE_2]|Varchar2(50)|[ADDRESS]| | |[LOCALITY]|Varchar2(50)|[ADDRESS]| | |[ZIP_POSTAL]|Varchar2(16)|[POSTAL CODE]| | |[MAIL_ADDRESS_LINE_1]|Varchar2(50)|[ADDRESS]| | |[MAIL_ADDRESS_LINE_2]|Varchar2(50)|[ADDRESS]| | |[MAIL_LOCALITY]|Varchar2(50)|[ADDRESS]| | |[MAIL_ZIP_POSTAL]|Varchar2(16)|[POSTAL CODE]| | |[PHONE_UNLISTED]|Varchar2(1)|[TOGGLE]| | |[PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[ALT_PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[CELLULAR_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[FAX_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[EMAIL_ADDRESS(Disambiguation)]|Varchar2(100)|[EMAIL]| | |[MARITAL_STATUS]|Varchar2(2)|[X_MARITAL_STATUS]| | |[MARRIED_DATE]|Date()|[DATE]| | |[NUMBER_DEPENDENTS]|Number(5)|[NUMBER5|NUMBERn]| | |[YEARS_EDUCATION]|Number(5)|[NUMBER5|NUMBERn]| | |[TRANSPORTATION]|Varchar2(2)|[X_TRANSPORTATION]| | |[BONDED_STATUS]|Varchar2(2)|[X_BONDED]| | |[CITIZEN_STATUS]|Varchar2(2)|[X_CITIZEN_STATUS]| | |[FOREIGN_CODE]|Varchar2(16)|[CODE]| | !![Derived Fields|DERIVED FIELDS] ||Column Name |[DRV_ADDRESS_LINE_1] |[DRV_ADDRESS_LINE_2] |[DRV_LOCALITY_STATE_ZIP] User Fields: Allowed\\ Audit Logging: Allowed\\ ---- ![Notes|Edit:Internal.P2K_HR_PERSONALS] [{InsertPage page='Internal.P2K_HR_PERSONALS' default='Click to create a new notes page'}]