| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
PUNCH_DTTM |
DateTime(26) |
TIMESTAMP |
Date and time when the punch occurred.
|
| 5 |
SEQ_NO |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
DUR |
Date(10) |
DATE NOT NULL |
Date Under Report associates time being reported, scheduled or paid, to a specific date.
|
| 8 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
|
| 9 |
SCHEDULE_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Scheduling Organizational Group Code
Prompt Table:
SCH_GROUP_TBL
|
| 10 |
SCHED_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Scheduled Work Hours
|
| 11 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SET_VLD_TL_01
|
| 12 |
WRKDAY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Workday ID
|
| 13 |
OFFDAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Day Indicator
N=Work Shift
Y=Off Shift
Default Value: N
|
| 14 |
SHIFT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shift ID
|
| 15 |
PUNCH_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
|
| 16 |
DELETE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Indicator is used to indicate whether a row has been logically deleted.
Y/N Table Edit
Default Value: N
|
| 17 |
SCHED_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Schedule Source indicates the source of Time Reporter Detail Schedule information.
E=Enterprise Learning Management
I=Third Party Import
L=Long Term Schedule
O=On-Line Change
|
| 18 |
TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
Prompt Table:
TL_TRC_TBL
|
| 19 |
TL_QUANTITY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This field represents the measure of Work in hrs,amount etc.,
|
| 20 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 21 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 22 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 23 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_TBL
|
| 24 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
COMP_RT_REG_VW
|
| 25 |
BILLABLE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Billable Indicator
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 26 |
OVERRIDE_RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Override Rate.
|
| 27 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 28 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
TL_BUS_UNIT_VW
|
| 29 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 30 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
TL_LOCATION_VW
|
| 31 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 32 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
TL_DEPT_TBL_VW
|
| 33 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 34 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
TL_JOBCODE_VW
|
| 35 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 36 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
Prompt Table:
TL_PRODUCT_TBL
|
| 37 |
CUSTOMER |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer
Prompt Table:
TL_CUSTOMER
|
| 38 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
TL_ACCTCD_BU_VW
|
| 39 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Business Unit
Prompt Table:
BUS_UNIT_PRJ_VW
|
| 40 |
BUSINESS_UNIT_PF |
Character(5) |
VARCHAR2(5) NOT NULL |
Perf Meas Business Unit
Prompt Table:
BUS_UNIT_TBL_PF
|
| 41 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
Prompt Table:
%EDIT_PROJECT
|
| 42 |
SETID_ACTIVITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity Set ID
|
| 43 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 44 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Type
Prompt Table:
TL_PROJ_RTYPE_V
|
| 45 |
SETID_RESOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Resource Set ID
|
| 46 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Category
Prompt Table:
%EDIT_RES_CAT
|
| 47 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Sub Category
Prompt Table:
%EDIT_RES_SUB
|
| 48 |
TASK |
Character(5) |
VARCHAR2(5) NOT NULL |
Task
Prompt Table:
TL_TASK
|
| 49 |
USER_FIELD_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 1
Prompt Table:
TL_USER_FIELD_1
|
| 50 |
USER_FIELD_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 2
Prompt Table:
TL_USER_FIELD_2
|
| 51 |
USER_FIELD_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 3
Prompt Table:
TL_USER_FIELD_3
|
| 52 |
USER_FIELD_4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 4
Prompt Table:
TL_USER_FIELD_4
|
| 53 |
USER_FIELD_5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 5
Prompt Table:
TL_USER_FIELD_5
|
| 54 |
RULE_ELEMENT_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 1
|
| 55 |
RULE_ELEMENT_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 2
|
| 56 |
RULE_ELEMENT_3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 3
|
| 57 |
RULE_ELEMENT_4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 4
|
| 58 |
RULE_ELEMENT_5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 5
|
| 59 |
SCH_CONFIG_IND1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.
|
| 60 |
SCH_CONFIG_IND2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.
|
| 61 |
SCH_CONFIG_IND3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.
|
| 62 |
SCH_CONFIG_IND4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.
|
| 63 |
TASK_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Profile ID
|
| 64 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
|
| 65 |
OVERRIDE_RSN_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Override Reason Code
|
| 66 |
PUNCH_END |
DateTime(26) |
TIMESTAMP |
Field typically used to record the end of a given punch (which is generally defined as the time of the consecutive punch, unless it is an OUT punch in which case BEGIN and END time is set to the same time).
|
| 67 |
HOLIDAY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday
Default Value: N
|
| 68 |
MAX_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Maximum Sequence Number
|