| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TL_RULE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Rule ID
|
| 2 |
COMPILE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Compiled?
Y/N Table Edit
Default Value: N
|
| 3 |
COMPILE_DTTM |
DateTime(26) |
TIMESTAMP |
Last Compiled
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_RULE_DEFN.DESCR
|
| 6 |
PERIOD_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Time Period ID
Prompt Table:
TL_TIME_PERIODS
|
| 7 |
TL_USER_EXIT |
Character(1) |
VARCHAR2(1) NOT NULL |
User Exit
Y/N Table Edit
Default Value: N
|
| 8 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 9 |
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.
Prompt Table:
TL_AE_SCTION_VW
|
| 10 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 11 |
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
|
| 12 |
TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Template ID
|
| 13 |
CHANGED |
Character(1) |
VARCHAR2(1) NOT NULL |
Field introduced with Rules to differentiate pure template-based rules from those subsequently customized.
Y/N Table Edit
Default Value: N
|