GPBR_FORMAT_IDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: GP_ACCMLTR_SRCH
Prompt Table: GP_ACCMLTR_SRCH
Prompt Table: GP_ACCMLTR_SRCH
10=Include
20=Exclude
Default Value: 10
10=Include
20=Exclude
Default Value: 10
GPBR_NRP_PYF_VW(SQL View) |
Index Back |
|---|---|
PaySlip FormatGeneral Data PaySlip |
| SELECT GPBR_FORMAT_ID , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , GPBR_PIN_PSLP1_NUM + 50000000 , GPBR_PSLP1_LCODE , GPBR_PIN_PSLP2_NUM + 50000000 , GPBR_PSLP2_LCODE , GPBR_PIN_PSLP3_NUM + 50000000 , GPBR_PSLP3_LCODE , GPBR_EARN_IE , GPBR_DED_IE ,GPBR_SELECT_ALL1 ,GPBR_SELECT_ALL2 FROM PS_GPBR_PAYSL_FORM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPBR_FORMAT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Format ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | GPBR_PIN_PSLP1_NUM | Number(8,0) | INTEGER NOT NULL |
Total Earnings. Accumulator for Payslip
Prompt Table: GP_ACCMLTR_SRCH |
| 7 | GPBR_PSLP1_LCODE | Character(7) | VARCHAR2(7) NOT NULL | Legal Code |
| 8 | GPBR_PIN_PSLP2_NUM | Number(8,0) | INTEGER NOT NULL |
Total Earnings. Accumulator for Payslip
Prompt Table: GP_ACCMLTR_SRCH |
| 9 | GPBR_PSLP2_LCODE | Character(7) | VARCHAR2(7) NOT NULL | Legal Code |
| 10 | GPBR_PIN_PSLP3_NUM | Number(8,0) | INTEGER NOT NULL |
Net Pay. Accumulator for Payslip
Prompt Table: GP_ACCMLTR_SRCH |
| 11 | GPBR_PSLP3_LCODE | Character(7) | VARCHAR2(7) NOT NULL | Legal Code |
| 12 | GPBR_EARN_IE | Character(2) | VARCHAR2(2) NOT NULL |
Earnings Include/Exclude
10=Include 20=Exclude Default Value: 10 |
| 13 | GPBR_DED_IE | Character(2) | VARCHAR2(2) NOT NULL |
Deduction Include/Exclude
10=Include 20=Exclude Default Value: 10 |
| 14 | GPBR_SELECT_ALL1 | Character(1) | VARCHAR2(1) NOT NULL | Select All Elements |
| 15 | GPBR_SELECT_ALL2 | Character(1) | VARCHAR2(1) NOT NULL | Select All |