| # |
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
MEA=Meal
MIS=Miscellaneous
MSP=Missing Punch
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 |
COMPILE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Compiled?
Y/N Table Edit
Default Value: N
|
| 5 |
COMPILE_DTTM |
DateTime(26) |
TIMESTAMP |
Last Compiled
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_TMPLT_RULE.DESCR
|
| 8 |
PERIOD_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Time Period ID
Prompt Table:
%RECNAME_EDIT
|
| 9 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 10 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 11 |
PUNCH_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
|
| 12 |
INCLUDE_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
Include IN Punch
Y/N Table Edit
Default Value: N
|
| 13 |
INCLUDE_OUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include OUT Punch
Y/N Table Edit
Default Value: N
|
| 14 |
INCLUDE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Include BREAK Punch
Y/N Table Edit
Default Value: N
|
| 15 |
INCLUDE_MEAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include MEAL Punch
Y/N Table Edit
Default Value: N
|
| 16 |
INCLUDE_XFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Include XFER Punch
Y/N Table Edit
Default Value: N
|
| 17 |
INCLUDE_ELAPSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Elapsed Time
Y/N Table Edit
Default Value: Y
|
| 18 |
USE_TSKPRF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate how task data is to be managed.
0=Use Default Task Profile
1=Use Specified Task Profile
2=Distribute Tasks Equally
3=Use Previous Row Tasks
Default Value: 3
|
| 19 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
|
| 20 |
TASK_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Profile ID
Prompt Table:
TL_TSKGRPPRF_VW
|
| 21 |
RUN_LOCATION_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Location Indicator - indicates whether Time Admin is to be executed on-line or in batch.
A=On-line and Batch
B=Batch Only
Default Value: B
|