GPMX_NRP_PYF_VW(SQL View) |
Index Back |
|---|---|
View for Payslip FormatView for Payslip Format |
| SELECT GPMX_FORMAT_ID , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , GPMX_PIN_PSLP1_NUM + 50000000 , GPMX_PIN_PSLP2_NUM + 50000000 , GPMX_PIN_PSLP3_NUM + 50000000 , GPMX_EARN_IE , GPMX_DED_IE , GPMX_SELECT_ALL1 , GPMX_SELECT_ALL2 , GPMX_TOTAL_OPTN FROM PS_GPMX_PAYSL_FORM |
| # | 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 |
| 7 | GPMX_PIN_PSLP2_NUM | Number(8,0) | INTEGER NOT NULL | Total Deductions. Payslip accumulator. |
| 8 | GPMX_PIN_PSLP3_NUM | Number(8,0) | INTEGER NOT NULL | Net Payment Accumulator for Payslip |
| 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 |
| 13 | GPMX_TOTAL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Payslip gross and Net option
A=Use Accumulators S=Selected Elements Default Value: S |