| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 4 |
AUDIT_STAMP |
DateTime(26) |
TIMESTAMP |
Date and Time Stamp
|
| 5 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 7 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 8 |
DUR |
Date(10) |
DATE NOT NULL |
Date Under Report associates time being reported, scheduled or paid, to a specific date.
|
| 9 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 10 |
PUNCH_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
|
| 11 |
PUNCH_TIME |
Time(15) |
TIMESTAMP |
punch time
|
| 12 |
PUNCH_DTTM |
DateTime(26) |
TIMESTAMP |
Date and time when the punch occurred.
|
| 13 |
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).
|
| 14 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
|
| 15 |
TIMEZONE2 |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
|
| 16 |
ST_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Submit Time Instance
|
| 17 |
BADGE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Badge ID
|
| 18 |
TCD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Collection Device Identification.
|
| 19 |
RULE_ELEMENT_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 1
|
| 20 |
RULE_ELEMENT_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 2
|
| 21 |
RULE_ELEMENT_3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 3
|
| 22 |
RULE_ELEMENT_4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 4
|
| 23 |
RULE_ELEMENT_5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 5
|
| 24 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
Prompt Table:
TL_TASKGRP_TBL
|
| 25 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 26 |
TASK_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Profile ID
Prompt Table:
TL_TSKPRF
|
| 27 |
TCD_SUPERVISR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
TCD Supervisor ID
|
| 28 |
OVERRIDE_RSN_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Override Reason Code
Prompt Table:
TL_OVRD_RSN_TBL
|
| 29 |
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
|
| 30 |
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
|
| 31 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Operator to Update
|
| 32 |
DTTM_MODIFIED |
DateTime(26) |
TIMESTAMP |
Datetime modified
|
| 33 |
DTTM_CREATED |
DateTime(26) |
TIMESTAMP |
Datetime Created
|
| 34 |
TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
Prompt Table:
TL_TRC_TBL
|
| 35 |
TL_QUANTITY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This field represents the measure of Work in hrs,amount etc.,
|
| 36 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 37 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 38 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 39 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_TBL
|
| 40 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
COMP_RT_REG_VW
|
| 41 |
BILLABLE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Billable Indicator
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 42 |
OVERRIDE_RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Override Rate.
|
| 43 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 44 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 45 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 46 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 47 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 48 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 49 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 50 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 51 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 52 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
|
| 53 |
CUSTOMER |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer
|
| 54 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
|
| 55 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Business Unit
|
| 56 |
BUSINESS_UNIT_PF |
Character(5) |
VARCHAR2(5) NOT NULL |
Perf Meas Business Unit
|
| 57 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
|
| 58 |
SETID_ACTIVITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity Set ID
|
| 59 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 60 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Type
|
| 61 |
SETID_RESOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Resource Set ID
|
| 62 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Category
|
| 63 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Sub Category
|
| 64 |
TASK |
Character(5) |
VARCHAR2(5) NOT NULL |
Task
|
| 65 |
USER_FIELD_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 1
|
| 66 |
USER_FIELD_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 2
|
| 67 |
USER_FIELD_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 3
|
| 68 |
USER_FIELD_4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 4
|
| 69 |
USER_FIELD_5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 5
|