!!!Alias: PPH (P2K_PR_PAY_HEADERS) Unique Keys: \\ Child Table: \\ Parent Table: \\ ERD: [ERD-PR55] \\ Pay 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] |[PAY_NUMBER]|Number(5)|[NUMBER5|NUMBERn]|Y| |[PPH_ID]|Number(10)|[ID]| |link to [P2K_PR_PAY_HEADERS] |[DGR_ID]|Number(10)|[ID]|Y|link to [P2K_CM_GROUPS] |[DSP_ID_HOME]|Number(10)|[ID]|Y|link to [P2K_CM_STATE_PROVINCES] |[DSP_ID_WORK]|Number(10)|[ID]|Y|link to [P2K_CM_STATE_PROVINCES] |[PCT_ID]|Number(10)|[ID]|Y|link to [P2K_PR_PAY_CATEGORIES] |[PPP_ID]|Number(10)|[ID]|Y|link to [P2K_PR_PAY_PERIODS] |[MUS_ID]|Number(10)|[ID]|Y|link to [P2K_AM_USERS] |[PBT_ID]|Number(10)|[ID]|Y|link to [P2K_PR_BATCHES] |[PRN_ID]|Number(10)|[ID]| |link to [P2K_PR_PAY_RUNS] |[PPTS_ID]|Number(10)|[ID]| |link to [P2K_PR_PAY_POINT_SETS] |[PPA_ID]|Number(10)|[ID]|Y|link to [P2K_PR_PAYROLLS] |[PDS_ID]|Number(10)|[ID]| |link to [P2K_PR_DISBURSEMENTS] |[DSD_ID]|Number(10)|[ID]| |link to [P2K_CM_SCHOOL_DISTRICTS] |[DTX_ID_HOME]|Number(10)|[ID]| |link to [P2K_CM_TAX_JURISDICTIONS] |[DTX_ID_WORK]|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| |[AUDITED]|Varchar2(1)|[TOGGLE]| | |[CHECK_NUMBER]|Number(10)|[NUMBER10|NUMBERn]| | |[FINAL_PAY_METHOD]|Varchar2(2)|[X_FINAL_PAY_METHOD]| | |[FIRST_PAY_IN_MONTH]|Varchar2(1)|[TOGGLE]| | |[FIRST_PAY_IN_PERIOD]|Varchar2(1)|[TOGGLE]| | |[HAND_CHECK]|Varchar2(1)|[TOGGLE]| | |[PAY_BY_CHECK]|Varchar2(2)|[X_PAY_BY_METHOD]| | |[PAY_HEADER_SOURCE]|Varchar2(2)|[X_PAY_HEADER_SOURCE]| | |[PAY_HEADER_STAGE]|Varchar2(2)|[X_PAY_HEADER_STAGE]| | |[PAY_RUN_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | |[POSTED_BENEFITS]|Varchar2(1)|[TOGGLE]| | |[POSTED_ATTENDANCE]|Varchar2(1)|[TOGGLE]| | |[QUICK_PAY]|Varchar2(1)|[TOGGLE]| | |[TAX_WEEKS]|Number(18)|[AMT12V6|AMTnn]| | |[TIMESHEET_RETURNED]|Varchar2(1)|[TOGGLE]| | |[CHECK_AMOUNT]|Number(18)|[AMT12V2|AMTnn]| | |[PAY_ISSUE_DATE]|Date()|[DATE]| | |[SUNDRY_ATTACHED]|Varchar2(1)|[TOGGLE]| | |[JOURNALIZED]|Varchar2(1)|[TOGGLE]| | |[TRACE_LEVEL]|Varchar2(1)|[X_TRACE_LEVEL]| | |[PROCESS_NUMBER]|Number(5)|[NUMBER5|NUMBERn]| | |[EAS_ID]|Number(10)|[ID]|Y|link to [P2K_HR_ASSIGNMENTS] |[JOURNALIZED_FUND]|Varchar2(1)|[TOGGLE]| | |[POSTED_RETIREMENT]|Varchar2(1)|[TOGGLE]| | |[FLSA_AUDIT_TEXT]|VARCHAR2(4000)| [VARCHAR4000|VARCHARnn]| | !![Derived Fields|DERIVED FIELDS] ||Column Name |[DRV_PAY_RUN_SEQUENCE_NUMBER] User Fields: Not Allowed\\ Audit Logging: Not Allowed\\ ---- ![Notes|Edit:Internal.P2K_PR_PAY_HEADERS] [{InsertPage page='Internal.P2K_PR_PAY_HEADERS' default='Click to create a new notes page'}]