!!!Alias: PGH (P2K_PR_GVT_HEADERS) Unique Keys: \\ Child Table: \\ Parent Table: \\ ERD: [ERD-PR90] \\ !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[PGR_ID]|Number(10)|[ID]|Y|link to [P2K_PR_GVT_RUNS] |[PGR_ID_PRINT_BY]|Number(10)|[ID]| |link to [P2K_PR_GVT_RUNS] |[PGR_ID_FILE_BY]|Number(10)|[ID]| |link to [P2K_PR_GVT_RUNS] |[DFD_ID]|Number(10)|[ID]|Y|link to [P2K_CM_FORM_DEFINITIONS] |[DGV_ID]|Number(10)|[ID]|Y|link to [P2K_CM_GOVT_REGISTRATIONS] |[EID_ID]|Number(10)|[ID]| |link to [P2K_HR_IDENTITIES] |[DSP_ID]|Number(10)|[ID]| |link to [P2K_CM_STATE_PROVINCES] |[DTX_ID]|Number(10)|[ID]| |link to [P2K_CM_TAX_JURISDICTIONS] |[DSD_ID]|Number(10)|[ID]| |link to [P2K_CM_SCHOOL_DISTRICTS] |[TAXATION_LEVEL]|Varchar2(4)|[X_TAXATION_LEVEL]|Y| |[TODATE_TYPE]|Varchar2(2)|[X_TODATE_TYPE]| | |[CALENDAR_PERIOD]|Number(10)|[NUMBER10|NUMBERn]| | |[TAXATION_LEVEL_SUFFIX]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[GVT_REMIT_TYPE]|Varchar2(2)|[X_GVT_REMIT_TYPE]| | |[GVT_PRINT_STAGE]|Varchar2(2)|[X_GVT_PRINT_STAGE]| | |[GVT_FILE_STAGE]|Varchar2(2)|[X_GVT_FILE_STAGE]| | |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[FORM_NUMBER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| !![Derived Fields|DERIVED FIELDS] ||Column Name |[DRV_GVT_REG_TAX_LEVEL] |[DRV_IDENTITY_INFO] |[DRV_TAX_INFO] |[DRV_TODATE_TYPE] User Fields: Allowed\\ Audit Logging: Allowed\\ ---- ![Notes|Edit:Internal.P2K_PR_GVT_HEADERS] [{InsertPage page='Internal.P2K_PR_GVT_HEADERS' default='Click to create a new notes page'}]