| # |
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 |
KEEP_GOING |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Going Flag for App Engine....
|
| 5 |
TL_RULE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Rule ID
|
| 6 |
TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Template ID
|
| 7 |
TEMPLATE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Template Type
ACC=Accumulator
APP=Approval Required
ATT=Attendance
CON=Consecutive Days
DFL=Default
DTH=Daily Threshold
EXC=Exception
GUA=Guaranteed Hours
HOL=Holiday
LIB=Library
MEA=Meal
MIS=Miscellaneous
MSP=Missing Punch
OPA=OPA Regulatory Rules
PRM=Premium Zone
PTR=Period Threshold
SCH=Schedule Deviation
SHF=Shift Premium
SPC=Specific Day
TSK=Task
|
| 8 |
RULE_PGM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Rule Program ID
|
| 9 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 10 |
SCRIPT_LOCATION |
Character(100) |
VARCHAR2(100) NOT NULL |
Script Location
|
| 11 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 12 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 13 |
PERIOD_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Time Period ID
|
| 14 |
TL_USER_EXIT |
Character(1) |
VARCHAR2(1) NOT NULL |
User Exit
|
| 15 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 16 |
ATTENDANCE_PGM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Attendance Program
|
| 17 |
AE_SECTION_UD |
Character(8) |
VARCHAR2(8) NOT NULL |
User defined AE Section Name.
This is an AE Section that a user has previously written to handle a specific rule that could not be defined using one of the delivered Rule Templates or Rule Components (Actions, Conditions, SQL Objects). The AE Section must be populated on the PS_TL_AE_SECTION table.
|
| 18 |
CHANGED |
Character(1) |
VARCHAR2(1) NOT NULL |
Field introduced with Rules to differentiate pure template-based rules from those subsequently customized.
|
| 19 |
INCLUDE_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
Include IN Punch
|
| 20 |
INCLUDE_OUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include OUT Punch
|
| 21 |
INCLUDE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Include BREAK Punch
|
| 22 |
INCLUDE_MEAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include MEAL Punch
|
| 23 |
INCLUDE_XFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Include XFER Punch
|
| 24 |
INCLUDE_ELAPSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Elapsed Time
|
| 25 |
LIST_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
List ID
|
| 26 |
LIST_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
List type for Values
0=TCD Group
1=TaskGroup
10=Company
11=Paygroup
12=Grade
13=Step
14=Punch Type
15=Employee Status
16=Employee Type
17=Attendance Violations
18=Absence Take
19=Compensatory Time Off Plan
2=Time Reporting Codes
20=Plan Type
21=Payable Status
22=Reported Status
23=Absence Status
24=Exception
25=Severity
26=Benefit Plan
27=Absence Entitlement
3=WorkGroup
4=Union Code
5=Jobcode
6=Department
7=Position number
8=Location
9=Shift
|
| 27 |
RULE_TEXT |
Long Character |
CLOB |
Rule SQL Text
|