| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RAPID_TMPLT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Rapid Time Template
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
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: P
|
| 4 |
EMPLID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee ID
Y/N Table Edit
Default Value: Y
|
| 5 |
EMPL_RCDN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Number
Y/N Table Edit
|
| 6 |
EMPL_NAME_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Name
Y/N Table Edit
Default Value: N
|
| 7 |
DUR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Under Report
Y/N Table Edit
Default Value: Y
|
| 8 |
TRC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC Flag
Y/N Table Edit
Default Value: N
|
| 9 |
TL_QUANTITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
TL Quantity Flag
Y/N Table Edit
Default Value: N
|
| 10 |
PUNCH_TYPE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Punch Type
Y/N Table Edit
Default Value: Y
|
| 11 |
PUNCH_TIME_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Punch Time
Y/N Table Edit
Default Value: Y
|
| 12 |
TIME_ZONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Zone
Y/N Table Edit
Default Value: Y
|
| 13 |
CURRCD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Code flag.
Y/N Table Edit
Default Value: N
|
| 14 |
RULE_ELE1_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 1 flag.
Y/N Table Edit
Default Value: N
|
| 15 |
RULE_ELE2_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 2 flag.
Y/N Table Edit
Default Value: N
|
| 16 |
RULE_ELE3_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Eleement 3 flag.
Y/N Table Edit
Default Value: N
|
| 17 |
RULE_ELE4_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 4 flag.
Y/N Table Edit
Default Value: N
|
| 18 |
RULE_ELE5_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Element 5 flag.
Y/N Table Edit
Default Value: N
|
| 19 |
TASKGROUP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used to determine if TASKGROUP field should appear on template.
Y/N Table Edit
Default Value: N
|
| 20 |
TASK_ID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Task
Y/N Table Edit
Default Value: N
|
| 21 |
LOCATION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Location flag.
Y/N Table Edit
Default Value: N
|
| 22 |
JOBCODE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Jobcode
Y/N Table Edit
Default Value: N
|
| 23 |
POSITION_NBR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Number
Y/N Table Edit
Default Value: N
|
| 24 |
COUNTRY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Country flag.
Y/N Table Edit
Default Value: N
|
| 25 |
STATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
State flag.
Y/N Table Edit
Default Value: N
|
| 26 |
LOCALITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Locality flag.
Y/N Table Edit
Default Value: N
|
| 27 |
OVRD_RT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rate flag.
Y/N Table Edit
Default Value: N
|
| 28 |
COMP_RTCD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Comp Rate Code flag.
Y/N Table Edit
Default Value: N
|
| 29 |
TASK_PRFID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Profile ID
Y/N Table Edit
Default Value: N
|
| 30 |
BILLIND_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Billable Indicator
Y/N Table Edit
Default Value: N
|
| 31 |
OVERD_RSN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Reason
Y/N Table Edit
Default Value: N
|
| 32 |
BUSINESS_UNIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit
Y/N Table Edit
Default Value: N
|
| 33 |
BUS_UNIT_PC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used to determine if BUSINESS_UNIT_PC field should appear on template.
Y/N Table Edit
Default Value: N
|
| 34 |
BUS_UNIT_PF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
PF Business Unit
Y/N Table Edit
Default Value: N
|
| 35 |
COMPANY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Company
Y/N Table Edit
Default Value: N
|
| 36 |
DEPTID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Department ID
Y/N Table Edit
Default Value: N
|
| 37 |
PRODUCT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product
Y/N Table Edit
Default Value: N
|
| 38 |
PROJECT_ID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Project ID
Y/N Table Edit
Default Value: N
|
| 39 |
CUSTOMER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer
Y/N Table Edit
Default Value: N
|
| 40 |
ACCTCD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Code
Y/N Table Edit
Default Value: N
|
| 41 |
RESRC_TYPE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Type
Y/N Table Edit
Default Value: N
|
| 42 |
RESRC_CAT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Category
Y/N Table Edit
Default Value: N
|
| 43 |
RESRC_SCAT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rsrc Sub-Category
Y/N Table Edit
Default Value: N
|
| 44 |
ACTIVITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity
Y/N Table Edit
Default Value: N
|
| 45 |
ACCOUNT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Account
Y/N Table Edit
Default Value: N
|
| 46 |
USER_FLD1_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field1
Y/N Table Edit
Default Value: N
|
| 47 |
USER_FLD2_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field2
Y/N Table Edit
Default Value: N
|
| 48 |
USER_FLD3_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field3
Y/N Table Edit
Default Value: N
|
| 49 |
USER_FLD4_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field4
Y/N Table Edit
Default Value: N
|
| 50 |
USER_FLD5_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field5
Y/N Table Edit
Default Value: N
|
| 51 |
COMMENTS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Comments flag.
Y/N Table Edit
Default Value: N
|