| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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
|
| 2 |
TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rule Template
Prompt Table:
TL_TMPLT_DEF_VW
|
| 3 |
TL_RULE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Rule ID
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_TMPLT_RULE.DESCR
|
| 6 |
PERIOD_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Time Period ID
Prompt Table:
%RECNAME_EDIT
|
| 7 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 8 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 9 |
INCLUDE_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
Include IN Punch
Y/N Table Edit
Default Value: N
|
| 10 |
INCLUDE_OUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include OUT Punch
Y/N Table Edit
Default Value: N
|
| 11 |
INCLUDE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Include BREAK Punch
Y/N Table Edit
Default Value: N
|
| 12 |
INCLUDE_MEAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include MEAL Punch
Y/N Table Edit
Default Value: N
|
| 13 |
INCLUDE_XFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Include XFER Punch
Y/N Table Edit
Default Value: N
|
| 14 |
INCLUDE_ELAPSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Elapsed Time
Y/N Table Edit
Default Value: Y
|
| 15 |
USE_TSKPRF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates how to assign Task Profile ID for IPT generated by the rule in question.
If the rule does not generate IPT (it may for example generate an Exception instead, then the setting is irrelevant).
0=Use Default Task Profile
1=Use Specified Task Profile
2=Distribute Tasks Equally
3=Use Previous Row Tasks
8=Enable Selection
9=Not Applicable For Template
Default Value: 3
|
| 16 |
TASK_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Profile ID
Prompt Table:
TL_TSKGRPPRF_VW
|