CAL_RUN_IDGP_PAYGROUPCAL_IDPrompt Table: GP_CS_CALID_PVW
GP_CS_GROSS_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 , ' ' , ' ' , A.PIN_GROSS_VAL , 0 , 0 , 0 , ' ' , A.RSLT_VER_NUM , A.RSLT_REV_NUM FROM PS_GP_CS_STAT_STG A WHERE A.USER_KEY1 = 'GROSS_NET' |
| # | 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_PVW |
| 6 | PIN_GROSS_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Gross Pay Value |
| 7 | GP_PREV_GROSS_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Gross 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 |
| 11 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 12 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |