| # |
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_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC Flag
Y/N Table Edit
Default Value: N
|
| 6 |
TRC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 7 |
TRC_TYPE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC flag.
Y/N Table Edit
Default Value: N
|
| 8 |
TRC_TYPE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC Type option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 9 |
UOM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit of Measure flag.
Y/N Table Edit
Default Value: N
|
| 10 |
UOM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit of Measure option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 11 |
CURRCD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Code flag.
Y/N Table Edit
Default Value: N
|
| 12 |
CURRCD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Code option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 13 |
TCD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Collection Device flag.
Y/N Table Edit
Default Value: N
|
| 14 |
TCD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Collection Device option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 15 |
RULE_ELE1_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 1 flag.
Y/N Table Edit
Default Value: N
|
| 16 |
RULE_ELE1_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 1 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 17 |
RULE_ELE2_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 2 flag.
Y/N Table Edit
Default Value: N
|
| 18 |
RULE_ELE2_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 2 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 19 |
RULE_ELE3_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Eleement 3 flag.
Y/N Table Edit
Default Value: N
|
| 20 |
RULE_ELE3_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 3 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 21 |
RULE_ELE4_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 4 flag.
Y/N Table Edit
Default Value: N
|
| 22 |
RULE_ELE4_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 4 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 23 |
RULE_ELE5_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 5 flag.
Y/N Table Edit
Default Value: N
|
| 24 |
RULE_ELE5_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 5 option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 25 |
COUNTRY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Country flag.
Y/N Table Edit
Default Value: N
|
| 26 |
COUNTRY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Country option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 27 |
STATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
State flag.
Y/N Table Edit
Default Value: N
|
| 28 |
STATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
State option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 29 |
LOCALITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Locality flag.
Y/N Table Edit
Default Value: N
|
| 30 |
LOCALITY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Locality option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 31 |
OVRD_RT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rate flag.
Y/N Table Edit
Default Value: N
|
| 32 |
OVRD_RT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rate option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 33 |
COMP_RTCD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Comp Rate Code flag.
Y/N Table Edit
Default Value: N
|
| 34 |
COMP_RTCD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Comp Rate Code option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 35 |
COMMENTS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Comments flag.
Y/N Table Edit
Default Value: N
|
| 36 |
COMMENTS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Comments option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 37 |
OVRD_RULES_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rules flag.
Y/N Table Edit
Default Value: N
|
| 38 |
OVRD_RULES_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rules option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 39 |
OVRD_RSN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Reason flag.
Y/N Table Edit
Default Value: N
|
| 40 |
OVRD_RSN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Reason option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 41 |
BILL_IND_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Indicator flag.
Y/N Table Edit
Default Value: N
|
| 42 |
BILL_IND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Indicator option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 43 |
TL_DAYOFWEEK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Day of Week flag
Y/N Table Edit
Default Value: N
|
| 44 |
TL_DAYOFWEEK_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Day of Week option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 45 |
TIMEZONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Zone flag.
Y/N Table Edit
Default Value: N
|
| 46 |
TIMEZONE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Zone option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 47 |
TASK_TMPLT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Template flag.
Y/N Table Edit
Default Value: N
|
| 48 |
TASK_TMPLT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Template option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 49 |
TASK_PRFL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Profile flag.
Y/N Table Edit
Default Value: N
|
| 50 |
TASK_PRFL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Profile option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 51 |
BADGE_ID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Badge ID flag.
Y/N Table Edit
Default Value: N
|
| 52 |
BADGE_ID_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Badge ID option.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 53 |
SAVE_FOR_LATER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Save For Later
Y/N Table Edit
Default Value: Y
|
| 54 |
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 Source
SYS=Time and Labor System
TCD=Time Collection Device
Y/N Table Edit
Default Value: N
|