GPTH_NRP_RCS_VW(SQL View) |
Index Back |
|---|---|
GPTH reconciliation ViewGPTH reconciliation summary report view to deal pin number |
| SELECT PROCESS_INSTANCE ,GP_PAYGROUP ,COMPANY ,COMPANY_DESCR ,GPTH_SRC_CAL_RN_ID ,GPTH_TGT_CAL_RN_ID ,PRD_END_DT ,PIN_NUM + 50000000 ,GPTH_RCN_PINDEC ,GPTH_SRC_CALC_RSLT ,GPTH_TGT_CALC_RSLT FROM PS_GPTH_RCN_S |
| # | 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 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 5 | GPTH_SRC_CAL_RN_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Group ID |
| 6 | GPTH_TGT_CAL_RN_ID | Character(18) | VARCHAR2(18) NOT NULL | Target Calendar Group ID |
| 7 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 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 |