GPMX_PAYSL_FORM(SQL Table) |
Index Back |
|---|---|
PaySlip FormatGeneral Data PaySlip |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPMX_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 | GPMX_PIN_PSLP1_NUM | Number(8,0) | INTEGER NOT NULL |
Total Earnings Accumulator for Payslip
Prompt Table: GP_PIN_AC0_VW |
| 7 | GPMX_PIN_PSLP2_NUM | Number(8,0) | INTEGER NOT NULL |
Total Deductions. Payslip accumulator.
Prompt Table: GP_PIN_AC0_VW |
| 8 | GPMX_PIN_PSLP3_NUM | Number(8,0) | INTEGER NOT NULL |
Net Payment Accumulator for Payslip
Prompt Table: GP_PIN_AC0_VW |
| 9 | GPMX_EARN_IE | Character(2) | VARCHAR2(2) NOT NULL |
Earnings Include/Exclude
10=Include 20=Exclude Default Value: 10 |
| 10 | GPMX_DED_IE | Character(2) | VARCHAR2(2) NOT NULL |
Deduction Include/Exclude
10=Include 20=Exclude Default Value: 10 |
| 11 | GPMX_SELECT_ALL1 | Character(1) | VARCHAR2(1) NOT NULL |
Select All Elements
Y/N Table Edit Default Value: N |
| 12 | GPMX_SELECT_ALL2 | Character(1) | VARCHAR2(1) NOT NULL |
Select All Members
Y/N Table Edit Default Value: N |