| # |
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 |
DUR |
Date(10) |
DATE NOT NULL |
Date Under Report associates time being reported, scheduled or paid, to a specific date.
|
| 5 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 6 |
PUNCH_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
|
| 7 |
PUNCH_TIME |
Time(15) |
TIMESTAMP |
punch time
|
| 8 |
PUNCH_DTTM |
DateTime(26) |
TIMESTAMP |
Date and time when the punch occurred.
|
| 9 |
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).
|
| 10 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
Default Value: TL_EMPL_DATA.TIMEZONE
Prompt Table:
PSTIMEZONE
|
| 11 |
TIMEZONE2 |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
|
| 12 |
ST_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Submit Time Instance
|
| 13 |
BADGE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Badge ID
|
| 14 |
TCD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Collection Device Identification.
|
| 15 |
RULE_ELEMENT_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 1
Prompt Table:
TL_RULE_ELEMNT1
|
| 16 |
RULE_ELEMENT_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 2
Prompt Table:
TL_RULE_ELEMNT2
|
| 17 |
RULE_ELEMENT_3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 3
Prompt Table:
TL_RULE_ELEMNT3
|
| 18 |
RULE_ELEMENT_4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 4
Prompt Table:
TL_RULE_ELEMNT4
|
| 19 |
RULE_ELEMENT_5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 5
Prompt Table:
TL_RULE_ELEMNT5
|
| 20 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
Prompt Table:
TL_TASKGRP_TBL
|
| 21 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 22 |
TASK_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Profile ID
Prompt Table:
TL_TASKGRP_PRFL
|
| 23 |
TCD_SUPERVISR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
TCD Supervisor ID
|
| 24 |
OVERRIDE_RSN_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Override Reason Code
Prompt Table:
TL_OVRD_RSN_TBL
|
| 25 |
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
|
| 26 |
REPORTED_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Reported Status
AP=Approved
DN=Denied
IP=Approval In Process
NA=Needs Approval
NW=New
PB=Pushed Back
PR=Processed
SB=Submitted
SV=Saved
|
| 27 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Operator to Update
|
| 28 |
DTTM_MODIFIED |
DateTime(26) |
TIMESTAMP |
Datetime modified
|
| 29 |
DTTM_CREATED |
DateTime(26) |
TIMESTAMP |
Datetime Created
|
| 30 |
PBM_ASGN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Assigment ID
|
| 31 |
REG_PAY_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Pay Rate
|
| 32 |
FO_MC_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines which action to take in Mass Change.
Used in Staffing Mass Changes.
A - Add
D - Delete
N - None
U - Update
A=Add
D=Delete
N=None
U=Update
|
| 33 |
TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
Prompt Table:
TL_TRC_TBL
|
| 34 |
TL_QUANTITY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This field represents the measure of Work in hrs,amount etc.,
|
| 35 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 36 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 37 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 38 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_TBL
|
| 39 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
COMP_RT_REG_VW
|
| 40 |
BILLABLE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Billable Indicator
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 41 |
OVERRIDE_RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Override Rate.
|
| 42 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 43 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
TL_BUS_UNIT_VW
|
| 44 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 45 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
TL_LOCATION_VW
|
| 46 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 47 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
TL_DEPT_TBL_VW
|
| 48 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 49 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
TL_JOBCODE_VW
|
| 50 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 51 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
Prompt Table:
TL_PRODUCT_TBL
|
| 52 |
CUSTOMER |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer
Prompt Table:
TL_CUSTOMER
|
| 53 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
TL_ACCTCD_BU_VW
|
| 54 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Business Unit
Prompt Table:
BUS_UNIT_PRJ_VW
|
| 55 |
BUSINESS_UNIT_PF |
Character(5) |
VARCHAR2(5) NOT NULL |
Perf Meas Business Unit
Prompt Table:
BUS_UNIT_TBL_PF
|
| 56 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
Prompt Table:
%EDIT_PROJECT
|
| 57 |
SETID_ACTIVITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity Set ID
|
| 58 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 59 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Type
Prompt Table:
TL_PROJ_RTYPE_V
|
| 60 |
SETID_RESOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Resource Set ID
|
| 61 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Category
Prompt Table:
%EDIT_RES_CAT
|
| 62 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Sub Category
Prompt Table:
%EDIT_RES_SUB
|
| 63 |
TASK |
Character(5) |
VARCHAR2(5) NOT NULL |
Task
Prompt Table:
TL_TASK
|
| 64 |
USER_FIELD_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 1
Prompt Table:
TL_USER_FIELD_1
|
| 65 |
USER_FIELD_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 2
Prompt Table:
TL_USER_FIELD_2
|
| 66 |
USER_FIELD_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 3
Prompt Table:
TL_USER_FIELD_3
|
| 67 |
USER_FIELD_4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 4
Prompt Table:
TL_USER_FIELD_4
|
| 68 |
USER_FIELD_5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 5
Prompt Table:
TL_USER_FIELD_5
|