| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
RUN_CTRL_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Run Control Type
AP=Approval
CC=Create T&L Business Calendar
CR=Crew Reporting
CS=Create Work Schedules
CT=Create Time
ED=Edit Time
LD=Labor Distribution
LR=Lumpsum Reporting
MC=Mass Change
PR=Pattern Reporting
PU=Update Payroll
RA=Rules Application
RF=Refresh Dynamic Groups
RR=Range of Date Reporting
RS=Resolve Schedules
RU=Rapid Update
VC=Virtual Task Clean Up
|
| 5 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 6 |
END_DT |
Date(10) |
DATE |
end date
|
| 7 |
TL_GROUP_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Time and Labor Groups
|
| 8 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 9 |
COUNTER |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Counter
|
| 10 |
TL_OUT_RECORD_NM |
Character(15) |
VARCHAR2(15) NOT NULL |
Output record name
|
| 11 |
START_MINI_DT |
Date(10) |
DATE |
Start Mini Date
|
| 12 |
END_MINI_DT |
Date(10) |
DATE |
End Mini Date
|
| 13 |
SQLID |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)
|
| 14 |
GRP_WHERE_CLS |
Long Character(4096) |
CLOB |
Where Clause for Groups
|
| 15 |
RETURN_CD |
Number(2,0) |
SMALLINT NOT NULL |
Return code from Remote Call
|
| 16 |
WRKDAY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Workday ID
|
| 17 |
SHIFT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shift ID
|
| 18 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 19 |
TL_APPR_PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Used to set a sequence priority for approvers assigned to a TL Approval Group
|
| 20 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 21 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 22 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 23 |
PUNCH_IN |
DateTime(26) |
TIMESTAMP |
Punch In
|
| 24 |
PUNCH_OUT |
DateTime(26) |
TIMESTAMP |
Punch out
|
| 25 |
SCH_PRODUCT_IND |
Character(2) |
VARCHAR2(2) NOT NULL |
Schedule Product Indicator
GP=GP Sch Resolve
TL=T&L Sch Resolve
|
| 26 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 27 |
EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Exist
|
| 28 |
ROWSECCLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
The class used to determine row level security
|
| 29 |
SCH_PRIM_ALT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether this is the employee's Primary or Alternate SChedule
A=Alternate
P=Primary
|
| 30 |
SCH_ORIDE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
This Option determines whether preference is given to Schedule Overrides entered through the PS Online pages over those imported from a Third Party system or not.
L=Take Last Update
O=Take Online Override
|
| 31 |
TL |
Character(1) |
VARCHAR2(1) NOT NULL |
PS/Time and Labor Product
|
| 32 |
INSTALLED_PAY_GBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Payroll Core
|
| 33 |
SCH_BASE_TZ |
Character(8) |
VARCHAR2(8) NOT NULL |
Base Timezone used in schedule reolution
|
| 34 |
NO_PAY_ROWS |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish unmapped TRC as No Pay
|
| 35 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 36 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 37 |
LANGUAGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Language Option
O=Specified Language
R=Recipient's Language
|