GP_PKG_IDGPTH_NRP_RCS_AD(SQL Table) |
Index Back |
|---|---|
Store reconcile summaryRecord to store reconciliation summary information. It contains all the fields required to generate Payroll Reconciliation Summary Report. The PeopleSoft Query that is used for generating Payroll Reconciliation Summary Report is mainly constructed based on this record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 6 | GPTH_SRC_CAL_RN_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Group ID |
| 7 | GPTH_TGT_CAL_RN_ID | Character(18) | VARCHAR2(18) NOT NULL | Target Calendar Group ID |
| 8 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 9 | GPTH_RCN_PINDEC | Character(30) | VARCHAR2(30) NOT NULL | Pin Description For Reconciliation Report |
| 10 | GPTH_SRC_CALC_RSLT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Source Actual Amount |
| 11 | GPTH_TGT_CALC_RSLT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Target Actual Amount |