| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 WORKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Workgroup
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %Date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_WRKGRP_TBL.DESCR
|
| 6 |
TRC_PROGRAM |
Character(5) |
VARCHAR2(5) NOT NULL |
TRC Program ID
Prompt Table:
TL_TRC_PGM_TBL
|
| 7 |
RULE_PGM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Rule Program ID
Prompt Table:
TL_RULE_PGM
|
| 8 |
TIME_RPTG_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Reporting Type
E=Exception Time Reporting
P=Positive Time Reporting
Default Value: E
|
| 9 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table:
HOLIDAY_TBL
|
| 10 |
PERIOD_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Time Period ID
Prompt Table:
TL_TR_PRDS_VW
|
| 11 |
SCHEDULE_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Scheduling Organizational Group Code
Prompt Table:
SCH_GROUP_TBL
|
| 12 |
SETID_SCHED |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID for Schedule ID
|
| 13 |
SCHEDULE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).
Prompt Table:
SCH_DEFN_CMN_VW
Set Control Field: SETID_SCHED
|
| 14 |
ROTATION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Rotation ID
Prompt Table:
SCH_DEFN_ROT_VW
|
| 15 |
COMP_TIME_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Compensatory Time Off Plan
Prompt Table:
TL_COMP_TIME
|
| 16 |
NEEDS_APPR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Needs Approval
Y/N Table Edit
Default Value: N
|
| 17 |
DAYBREAKER |
Time(15) |
TIMESTAMP NOT NULL |
Day Breaker Time
|
| 18 |
DAYBREAKER_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Day Breaker Option
B=Begin Time Of Shift
E=End Time Of Shift
M=Majority Of Shift
S=Split By Day Breaker
Default Value: B
|
| 19 |
ROUNDING_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Governs the rounding scheme for post-rule rounding in the TA process.
D=Round By Day
N=No Rounding
S=Round Each Entry
Default Value: N
|
| 20 |
ROUNDING_OPTS_PCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Governs the rounding applied to individual punches and/or the total duration for a days worth of punches as a whole.
D=Round By Day
N=No Rounding
P=Round Each Punch
Default Value: N
|
| 21 |
ROUNDING_INTERVALS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Rounding interval configuration used on Workgroup
|
| 22 |
ROUNDING_MARKER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Rounding Marker (Minutes)
|
| 23 |
DAYBREAKER_RANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
The Day Breaker Range defines how to determine which date to allocate the day's hours to, in conjunction with the time of the Day Breaker. The options are to apply the hours to the date when the day begins or the date when the day ends.
For example, if the Day Breaker is set to 2:00PM, should the hours prior to 2:00PM be considered part of this day (End option for Day Breaker range), or the previous day (Begin option for Day Breaker Range).
B=Range Start Day
E=Range End Day
Default Value: B
|
| 24 |
TL_OT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Overtime Limit ID
Prompt Table:
TL_OT_SETUP_TBL
|
| 25 |
INCL_ML_BRK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Totaling
1=Exclude Breaks and Meals
2=Include Meals
3=Include Breaks
4=Include Breaks and Meals
Default Value: 1
|
| 26 |
TL_APRV_RPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve Reported Time
Y/N Table Edit
Default Value: N
|
| 27 |
SCHED_DEV |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Schedule Deviation
Y/N Table Edit
Default Value: N
|
| 28 |
SCHED_TOLERANCE |
Number(2,0) |
SMALLINT NOT NULL |
Tolerance from Schedule (min.)
|
| 29 |
TL_EXCLUDE_HOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Holiday Configuration at Workgroup level
Y/N Table Edit
Default Value: N
|
| 30 |
TL_CR_PARTIAL_HRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Parital Work hours configuration at Workgroup level
Y/N Table Edit
Default Value: N
|
| 31 |
TL_APPR_PAY_ADHOC |
Character(7) |
VARCHAR2(7) NOT NULL |
TL adhoc approval group for payable time
Prompt Table:
TL_APP_GRP_VW
|
| 32 |
TL_APPR_PAY_DEFN |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Payable Time Definition ID
Prompt Table:
TL_AWE_PAY_VW
|
| 33 |
TL_APPR_PAY_GRP1 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL Approval group on the workgroup and TRC page for payable time approvals
Prompt Table:
TL_APP_GRP_VW
|
| 34 |
TL_APPR_PAY_GRP2 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL approval group on the workgroup and trc page for payable time approvals
Prompt Table:
TL_APP_GRP_VW
|
| 35 |
TL_APPR_PAY_PRCS |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Payable Time Process ID
|
| 36 |
TL_APPR_RPT_ADHOC |
Character(7) |
VARCHAR2(7) NOT NULL |
TL adhoc approval group for reported time
Prompt Table:
TL_APP_GRP_VW
|
| 37 |
TL_APPR_RPT_DEFN |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Reported Time Definition ID
Prompt Table:
TL_AWE_RPT_VW
|
| 38 |
TL_APPR_RPT_GRP1 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL Approval Group on the workgroup and TRC page for reported time approvals
Prompt Table:
TL_APP_GRP_VW
|
| 39 |
TL_APPR_RPT_GRP2 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL Approval Group on the workgroup and TRC page for reported time approvals
Prompt Table:
TL_APP_GRP_VW
|
| 40 |
TL_APPR_RPT_PRCS |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Reported Time Process ID
|
| 41 |
ALLOW_MGR_SUBMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator field introduced for controlling managers access to employees timesheet.
Y/N Table Edit
Default Value: Y
|
| 42 |
NOTIFY_EMPLOYEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field introduced to control whether manager's modifications to the employees time should require a notification to be sent.
Y/N Table Edit
Default Value: N
|
| 43 |
TL_TS_EE_SIGNOFF |
Character(1) |
VARCHAR2(1) NOT NULL |
Field introduced to configure whether it is required for the employee to sign off on his timesheet when time is submitted.
Y/N Table Edit
Default Value: N
|
| 44 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 45 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 46 |
MESSAGE_NBR02 |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 47 |
TL_APPR_OT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Overtime Request Approval Flag
Y/N Table Edit
Default Value: N
|
| 48 |
TL_APPR_OT_PRCS |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Overtime Request Process ID
|
| 49 |
TL_APPR_OT_DEFN |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Overtime Request Definition ID
Prompt Table:
TL_AWE_OT_VW
|
| 50 |
TL_APPR_OT_GRP1 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL Approval Group for Overtime Request approvals
Prompt Table:
TL_APP_GRP_VW
|
| 51 |
TL_APPR_OT_GRP2 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL Approval Group for Overtime Request approvals
Prompt Table:
TL_APP_GRP_VW
|
| 52 |
TL_APPR_OT_ADHOC |
Character(7) |
VARCHAR2(7) NOT NULL |
TL adhoc approval group for Overtime Request
Prompt Table:
TL_APP_GRP_VW
|
| 53 |
TL_PAYABLE_TM_RNG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payable Time Date Range
DR=Date Range
PP=Pay Period
TP=Time Period
Default Value: DR
|
| 54 |
TL_INSTALL_OVRRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Installation Overrride field for workgroup setup.
Y/N Table Edit
Default Value: N
|
| 55 |
TL_DAYS_AFT_TERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Enrollment Inactivation
D=Days After Termination
N=Next Time Period
Default Value: D
|
| 56 |
TL_TERM_DAYS_LIMIT |
Number(3,0) |
SMALLINT NOT NULL |
Enrollment Termination Limit
Default Value: 0
|
| 57 |
TL_USE_QF |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Quick-Fill for Time Details
Y/N Table Edit
Default Value: N
|
| 58 |
TL_EMP_ESIGN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Acknowledgement ID for employee
Prompt Table:
TL_ESIGN_ID_VW
|
| 59 |
TL_ALT_ESIGN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Acknowledgement ID for alternate employee
Prompt Table:
TL_ESIGN_ID_VW
|
| 60 |
TL_APRV_SCH_RP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve Replace Schedule
Y/N Table Edit
Default Value: N
|
| 61 |
TL_APPR_SCH_R_DEFN |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Reported Time Definition ID
Prompt Table:
TL_AWE_SCH_R_VW
|
| 62 |
TL_APR_SCH_R_ADHOC |
Character(7) |
VARCHAR2(7) NOT NULL |
TL adhoc approval group for reported time
Prompt Table:
TL_APP_GRP_VW
|
| 63 |
TL_APPR_SCH_R_PRCS |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Reported Time Process ID
|
| 64 |
TL_APRV_SCH_SP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve Swap Schedule
Y/N Table Edit
Default Value: N
|
| 65 |
TL_APPR_SCH_S_DEFN |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Reported Time Definition ID
Prompt Table:
TL_AWE_SCH_S_VW
|
| 66 |
TL_APR_SCH_S_ADHOC |
Character(7) |
VARCHAR2(7) NOT NULL |
TL adhoc approval group for reported time
Prompt Table:
TL_APP_GRP_VW
|
| 67 |
TL_APPR_SCH_S_PRCS |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Reported Time Process ID
|
| 68 |
TL_MEAL_BREAK_WVR |
Character(1) |
VARCHAR2(1) NOT NULL |
New field created for Override Meal Break Waiver Setup
Y/N Table Edit
Default Value: N
|