GP_PSLP_SORT(SQL Table) |
Index Back |
|---|---|
Print Payslip Sort OrderSequence Print Payslip |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_CNTRY_PSLP_SORT |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_COUNTRY |
| 2 | GP_PSLP_SORT |
Character(12) | VARCHAR2(12) NOT NULL | Payslip Sort |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | GP_PSLP_SEQ01 | Character(4) | VARCHAR2(4) NOT NULL |
Order 01
Prompt Table: GP_PSLP_ORD_VW |
| 6 | GP_PSLP_ASC_DESC01 | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 01
A=Ascending D=Descending Default Value: A |
| 7 | GP_PSLP_SEQ02 | Character(4) | VARCHAR2(4) NOT NULL |
Order 02
Prompt Table: GP_PSLP_ORD_VW |
| 8 | GP_PSLP_ASC_DESC02 | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 02
A=Ascending D=Descending |
| 9 | GP_PSLP_SEQ03 | Character(4) | VARCHAR2(4) NOT NULL |
Order 03
Prompt Table: GP_PSLP_ORD_VW |
| 10 | GP_PSLP_ASC_DESC03 | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 03
A=Ascending D=Descending |
| 11 | GP_PSLP_SEQ04 | Character(4) | VARCHAR2(4) NOT NULL |
Order 04
Prompt Table: GP_PSLP_ORD_VW |
| 12 | GP_PSLP_ASC_DESC04 | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 04
A=Ascending D=Descending |
| 13 | GP_PSLP_SEQ05 | Character(4) | VARCHAR2(4) NOT NULL |
Order 05
Prompt Table: GP_PSLP_ORD_VW |
| 14 | GP_PSLP_ASC_DESC05 | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 05
A=Ascending D=Descending |
| 15 | 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. |
| 16 | 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. |