GP_PSLP_ASGN(SQL Table) |
Index Back |
|---|---|
Payslip Template AssignmentTemplates assign to a population of payees |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_CNTRY_PSLP_ASGN |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: %EDITTABLE |
| 2 | GP_PSLP_ASGN_CD |
Character(12) | VARCHAR2(12) NOT NULL | Assignment Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | GP_CNTRY_PSLP_TMPL | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_COUNTRY |
| 6 | GP_PSLP_TMPL | Character(12) | VARCHAR2(12) NOT NULL |
This field is used to uniquely identify a payslip template.
Prompt Table: GP_PSLP_TPL1_VW |
| 7 | GP_CNTRY_PSLP_TMSS | Character(3) | VARCHAR2(3) NOT NULL |
ePay Template Country
Prompt Table: GP_COUNTRY |
| 8 | GP_PSLP_TMPL_SS | Character(12) | VARCHAR2(12) NOT NULL |
ePay Template (Self Service)
Prompt Table: GP_PSLP_TPL1_VW |
| 9 | GP_PSLP_POPUL_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Payslip Population Selection
A=All Payees E=Payee F=Formula Element G=Human Resources Group O=Other Criteria P=Global Payroll Payee List Default Value: A Prompt Table: GP_PSLP_POP1_VW |
| 10 | GROUP_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL |
Group List
Prompt Table: GP_GRP_LIST_VW |
| 11 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PSLP_PYG1_VW |
| 12 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table: GP_RUN_TYPEP_VW |
| 13 | 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. |
| 14 | 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. |