| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rule Template
|
| 2 |
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
|
| 3 |
CORE_COMPONENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether the object is delivered by PeopleSoft.
Y/N Table Edit
Default Value: N
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_TMPLT_DEFN.DESCR
|
| 6 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
PSPACKAGE_VW
|
| 7 |
PACKAGEID |
Character(30) |
VARCHAR2(30) NOT NULL |
Package Name (see PSDIAGREG).
|
| 8 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
PSMSGSETDEFN
|
| 9 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
PSMSGCATDEFN
|
| 10 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table:
TL_TMPLT_PNL_VW
|
| 11 |
TL_TIME_SELECTOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Field introduced for Rule Template Definition to control the behavior of the punch type selector on the Template Rule UI.
CC=Controlled By Code
IO=In Punch Only
NA=Not Applicable (Disable)
OO=Out Punch Only
RN=Required, No Restriction
RO=Required, No Out Punch
RP=Required, No Elapsed
RX=Require Punch, Except Out
Default Value: RO
|
| 12 |
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: 8
|
| 13 |
TL_USER_EXIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Dedicated App Class
Y/N Table Edit
Default Value: N
|
| 14 |
RECNAME_EDIT |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table for Record
Prompt Table:
TL_PERIOD_VW_VW
|
| 15 |
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
|
| 16 |
CREATE_REPLACE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether a rule should create time in place of or in addition to the time used as the criteria to generate another entry.
C=Create In Addition
N=Not Applicable
R=Create As Replacement
Default Value: N
|
| 17 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|