!!!Alias: PTD Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Todate Headers !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[EEM_ID]|Number(10)|[ID]|Y|link to [P2K_HR_EMPLOYMENTS] |[EAS_ID]|Number(10)|[ID]| |link to [P2K_HR_ASSIGNMENTS] |[DGR_ID]|Number(10)|[ID]| |link to [P2K_CM_GROUPS] |[DSP_ID_HOME]|Number(10)|[ID]| |link to [P2K_CM_STATE_PROVINCES] |[DSP_ID_WORK]|Number(10)|[ID]| |link to [P2K_CM_STATE_PROVINCES] |[DSD_ID]|Number(10)|[ID]| |link to [P2K_CM_SCHOOL_DISTRICTS] |[DTX_ID_WORK]|Number(10)|[ID]| |link to [P2K_CM_TAX_JURISDICTIONS] |[DTX_ID_HOME]|Number(10)|[ID]| |link to [P2K_CM_TAX_JURISDICTIONS] |[TODATE_TYPE]|Varchar2(2)|[X_TODATE_TYPE]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CALENDAR_PERIOD]|Number(10)|[NUMBER10|NUMBERn]| | |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[DGVS_ID_FED]|Number(10)|[ID]| |link to [P2K_CM_GOVT_REGIST_SETS] |[DGVS_ID_STATE]|Number(10)|[ID]| |link to [P2K_CM_GOVT_REGIST_SETS] |[DGVS_ID_LOCAL]|Number(10)|[ID]| |link to [P2K_CM_GOVT_REGIST_SETS] User Fields: Allowed\\ Audit Logging: Not Allowed\\