| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TIME_RPTG_TMPLT |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Reporting Template ID
|
| 2 |
TIME_RPTR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether a Time Reporter is primarily reports Elapsed Time or Punch Time.
E=Elapsed Time Reporter
P=Punch Time Reporter
Default Value: E
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_RPTD_TMPLT.DESCR
|
| 5 |
TRC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 6 |
TRC_TYPE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC Type option.
N=Hide Field
Y=Show Field
Default Value: N
|
| 7 |
UOM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit of Measure option.
N=Hide Field
Y=Show Field
Default Value: N
|
| 8 |
CURRCD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Code option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 9 |
TCD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Collection Device option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 10 |
RULE_ELE1_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 1 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 11 |
RULE_ELE2_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 2 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 12 |
RULE_ELE3_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 3 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 13 |
RULE_ELE4_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 4 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 14 |
RULE_ELE5_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 5 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 15 |
COUNTRY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Country option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 16 |
STATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
State option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 17 |
LOCALITY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Locality option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 18 |
OVRD_RT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rate option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 19 |
COMP_RTCD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Comp Rate Code option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 20 |
OVRD_RSN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Reason option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 21 |
BILL_IND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Indicator option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 22 |
TIMEZONE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Zone option.
N=Hide Field
Y=Show Field
Default Value: N
|
| 23 |
TASK_TMPLT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Template flag.
Y/N Table Edit
Default Value: N
|
| 24 |
TASK_TMPLT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Template option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 25 |
TASK_PRFL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Profile option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 26 |
BADGE_ID_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Badge ID option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 27 |
SAVE_FOR_LATER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Save For Later Option
A=Always Validate
B=Never Validate
N=Save For Later Is Not Allowed
U=Use User Preference
Y=Prompt For Validation
Default Value: Y
|
| 28 |
TASKGROUP_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Taskgroup
N=Entry Not Allowed
Y=Entry Allowed
Default Value: Y
|
| 29 |
RT_SOURCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to indicate whether or not Reported Time Source should be enterable on the reporting interfaces.
N=Hide Field
Y=Show Field
Default Value: N
|
| 30 |
RT_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Reported Time Source. the originator of Reported Time
AM=Absence Management
MD=Mobile Device
ONL=Online
SCH=Schedule
SYS=Time and Labor System
TCD=Time Collection Device
Y/N Table Edit
Default Value: N
|
| 31 |
VIEW_BY_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Setting that allows control over the View By selector on the timesheet.
BB=By Bi-Week
BD=By Day
BM=By Month
BP=By Reporting Period
BW=By Week
NR=No Restrictions
Default Value: NR
|
| 32 |
APPLY_RULES |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Rules
B=Enable in All Views
E=Enable in Employee View Only
M=Enable in Manager View Only
Default Value: B
|
| 33 |
APPLY_SCHED_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Field introduced to control whether user has access to the Apply Schedules button on the timesheet interface.
N=Do Not Enable In Manager View
Y=Enable in Manager View
Default Value: Y
|
| 34 |
ALL_PUNCH_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Field introduced to control whether user has access to the Show All Punches button on the timesheet interface.
N=Disable
Y=Enable
Default Value: N
|
| 35 |
SHOW_AEVT_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Field introduced to control section display on timesheet.
EO=Show in Employee View Only
HS=Hide Section
MO=Show In Manager View Only
SS=Show Section
Default Value: SS
|
| 36 |
SHOW_ABAL_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Field introduced to control section display on timesheet.
EO=Show in Employee View Only
HS=Hide Section
MO=Show In Manager View Only
SS=Show Section
Default Value: SS
|
| 37 |
SHOW_ATND_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Field introduced to control section display on timesheet.
EO=Show in Employee View Only
HS=Hide Section
MO=Show in Manager View Only
SS=Show Section
Default Value: HS
|
| 38 |
SHOW_CMLV_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Field introduced to control section display on timesheet.
EO=Show in Employee View Only
HS=Hide Section
MO=Show in Manager View Only
SS=Show Section
Default Value: SS
|
| 39 |
SHOW_ESTM_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Field introduced to control section display on timesheet.
HS=Hide on Timesheet
SS=Show on Timesheet
Default Value: SS
|
| 40 |
SHOW_EXCP_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Field introduced to control section display on timesheet.
EO=Show in Employee View Only
HS=Hide Section
MO=Show in Manager View Only
SS=Show Section
Default Value: SS
|
| 41 |
SHOW_PYBL_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Field introduced to control section display on timesheet.
EO=Show in Employee View Only
HS=Hide Section
MO=Show in Manager View Only
SS=Show Section
Default Value: SS
|
| 42 |
SHOW_SUMM_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Field introduced to control section display on timesheet.
EO=Show in Employee View Only
HS=Hide Section
MO=Show in Manager View Only
SS=Show Section
Default Value: SS
|
| 43 |
SUBMIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field introduced to allow controlling the Submit confirmation on the timesheet.
C=Confirm
S=Skip Confirmation
U=Use User Preference
Default Value: C
|
| 44 |
TL_PAY_APRVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Payable Time Needs Approval
B=Both Detail and Summary Page
D=Detail Page Only
S=Summary Page Only
Default Value: B
|
| 45 |
TL_PRNT_TMSHEET |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Timesheet
N=Disable
Y=Enable
Default Value: N
|
| 46 |
TL_RPT_APRVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Field put to use to control whether manager can approve time from summary page or must review the detail content
B=Both Detail and Summary Page
D=Detail Page Only
S=Summary Page Only
Default Value: B
|
| 47 |
USE_INSTALL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Field introduced to control whether or not to display this piece of information as additional job-related information on employee time entry and review pages such as the timesheet.
Y/N Table Edit
Default Value: Y
|
| 48 |
TIME_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Time option for Punch Time reporters
D=Disabled
E=Enabled
Default Value: D
|