PROCESS_INSTANCEGP_PAYGROUPCOMPANYEMPLIDGPTH_CAL_RSLT_FLAGS=Source Result of alculation
T=Target Result of Calculation
GPTH_RCN_D(SQL Table) |
Index Back |
|---|---|
Store reconcile detailRecord to store reconciliation detail information. It contains all the fields required to generate Payroll Reconciliation Details Report. The PeopleSoft Query that is used for generating Payroll Reconciliation Details Report is mainly constructed based on this record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | GPTH_CAL_RSLT_FLAG |
Character(1) | VARCHAR2(1) NOT NULL |
flag to indicate calculation result belong to Source Group or Target Group
S=Source Result of alculation T=Target Result of Calculation |
| 6 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 7 | GPTH_SRC_CAL_RN_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Group ID |
| 8 | GPTH_TGT_CAL_RN_ID | Character(18) | VARCHAR2(18) NOT NULL | Target Calendar Group ID |
| 9 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 10 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 11 | GPTH_RCN_PINDEC | Character(30) | VARCHAR2(30) NOT NULL | Pin Description For Reconciliation Report |
| 12 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 13 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 14 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 15 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 16 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 17 | GPTH_SRC_COMPRATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Source Basic Salary |
| 18 | GPTH_TGT_COMPRATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Target Basic Salary |
| 19 | GPTH_ACTIONS | Character(254) | VARCHAR2(254) NOT NULL | Action List |
| 20 | GPTH_EFFDT | Character(254) | VARCHAR2(254) NOT NULL | Effective date list |
| 21 | GPTH_DAY | Character(254) | VARCHAR2(254) NOT NULL | Day List |
| 22 | GPTH_EMPL_NO | Character(254) | VARCHAR2(254) NOT NULL | Indicate the number of employee according to action |
| 23 | GPTH_SRC_CALC_RSLT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Source Actual Amount |
| 24 | GPTH_TGT_CALC_RSLT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Target Actual Amount |