GP_CNTRY_PSLP_SCTPrompt Table: GP_PSLP_CTRY_VW
GP_PSLP_SECTIONA=Active
I=Inactive
Default Value: A
B=Both Static and Dynamic
D=Dynamic
S=Static
Default Value: S
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
GP_PSLP_SCT(SQL Table) |
Index Back |
|---|---|
Payslip Section DefinitionPayslip Section Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_CNTRY_PSLP_SCT |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_PSLP_CTRY_VW |
| 2 | GP_PSLP_SECTION |
Character(12) | VARCHAR2(12) NOT NULL | Payslip Section |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | GP_PSLP_SECT_STYLE | Character(1) | VARCHAR2(1) NOT NULL |
The style attribute of a section determines if it is static, dynamic or both
B=Both Static and Dynamic D=Dynamic S=Static Default Value: S |
| 7 | GP_PSLP_SECT_TOTAL | Number(2,0) | SMALLINT NOT NULL | Vertical Section size |
| 8 | GP_PSLP_SECT_DTL | Number(3,0) | SMALLINT NOT NULL | Vertical Section size |
| 9 | GP_PSLP_BLK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Payslip Block Flag
Y/N Table Edit Default Value: N |
| 10 | GP_PSLP_PAYCHKSECT | Character(1) | VARCHAR2(1) NOT NULL |
Payslip Pay Check Section
Y/N Table Edit Default Value: N |
| 11 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 12 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | COMMENTS | Long Character | CLOB | Comment |