GPMY_RC_LVELIAB(SQL Table) |
Index Back |
|---|---|
Run Cntl - Leave Liab RptThis table will be used to record the parameters for running the GP MYS Liability report program. The key fields for this table include the operator ID and run control ID. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 4 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 5 | ASOFDATE | Date(10) | DATE NOT NULL |
As of Date
Default Value: %Date |
| 6 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP_OPR_VW |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL_ACCESS |
| 8 | USED_BY | Character(1) | VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries C=Specific Country Default Value: C |
| 9 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: AUS |