CAL_RUN_IDGP_PAYGROUPCAL_IDPrompt Table: GP_CS_CALID_AVW
GP_CAL_ACUM_VW(SQL View) |
Index Back |
|---|---|
GP Related Content Grs/Net VWUsed to obtain the gross/net data for the related content payroll status monitor. |
| SELECT A.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , ' ' , ' ' , SUM(A.PIN_GROSS_VAL) , 0 , 0 , 0 , ' ' FROM PS_GP_CS_STAT_STG A WHERE A.USER_KEY1 = 'ACUM_RSLT' GROUP BY A.CAL_RUN_ID , A.CAL_ID , A.GP_PAYGROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 3 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 4 | GP_PREV_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Previous Calendar Group ID |
| 5 | GP_PREV_CAL_ID | Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GP_CS_CALID_AVW |
| 6 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 7 | GP_PREV_ACUM_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Net Pay Value |
| 8 | GP_CS_AMT_DIFF | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Gross Pay Value |
| 9 | GP_CS_PCT_DIFF | Signed Number(22,6) | DECIMAL(20,6) NOT NULL | Percentage Difference |
| 10 | GP_CS_ALERT_ICN | Image Reference(30) | VARCHAR2(30) | Global Payroll Related Content Error Icon |