| # |
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 |
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_BEGIN |
DateTime(26) |
TIMESTAMP |
Punch Time
|
| 8 |
PUNCH_BEGIN_R |
DateTime(26) |
TIMESTAMP |
Punch In Rounded
|
| 9 |
TIME_IN_MIN1 |
Number(4,0) |
SMALLINT NOT NULL |
Minutes From Midnight
|
| 10 |
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).
|
| 11 |
PUNCH_END_R |
DateTime(26) |
TIMESTAMP |
Punch In Rounded
|
| 12 |
TIME_IN_MIN2 |
Number(4,0) |
SMALLINT NOT NULL |
Minutes From Midnight
|
| 13 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
|
| 14 |
TIMEZONE2 |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
|
| 15 |
TCD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Collection Device Identification.
|
| 16 |
BADGE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Badge ID
|
| 17 |
EST_GROSS |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Estimated Gross
|
| 18 |
LBR_DIST_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Labor Distribution Amount
|
| 19 |
DILUTED_GROSS |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Diluted Labor Distribution Amt
|
| 20 |
CURRENCY_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 21 |
CURRENCY_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 22 |
RULE_ELEMENT_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 1
|
| 23 |
RULE_ELEMENT_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 2
|
| 24 |
RULE_ELEMENT_3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 3
|
| 25 |
RULE_ELEMENT_4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 4
|
| 26 |
RULE_ELEMENT_5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Element 5
|
| 27 |
RULE_FLAG1 |
Number(1,0) |
SMALLINT NOT NULL |
Rule Flag
|
| 28 |
RULE_FLAG2 |
Number(1,0) |
SMALLINT NOT NULL |
Rule Flag
|
| 29 |
RULE_FLAG3 |
Number(1,0) |
SMALLINT NOT NULL |
Rule Flag
|
| 30 |
RULE_FLAG4 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Rule Flag
|
| 31 |
RULE_FLAG5 |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Rule Flag
|
| 32 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
|
| 33 |
DFLT_TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
|
| 34 |
TASK_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Profile ID
|
| 35 |
DFLT_TASK_PROF_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Profile ID
|
| 36 |
DFLT_TASKTMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Profile Template ID
|
| 37 |
PERIOD_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
|
| 38 |
PERIOD_SEQUENCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number of Period ID
|
| 39 |
PAYABLE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Payable Status
AP=Approved
CL=Closed
DL=Diluted
DN=Denied
ES=Estimated
IG=Ignore
NA=Needs Approval
NP=No Pay
OE=Online Estimate
PB=Pushed Back
PD=Distributed
RP=Rejected by Payroll
RV=Reversed Check
SP=Sent to Payroll
TP=Taken by Payroll
|
| 40 |
IN_BATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
In Batch
|
| 41 |
OFFDAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Day Indicator
N=Work Shift
Y=Off Shift
Y/N Table Edit
|
| 42 |
TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
Prompt Table:
TL_TRC_TBL
|
| 43 |
TL_QUANTITY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This field represents the measure of Work in hrs,amount etc.,
|
| 44 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 45 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 46 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 47 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_TBL
|
| 48 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
COMP_RT_REG_VW
|
| 49 |
BILLABLE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Billable Indicator
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 50 |
OVERRIDE_RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Override Rate.
|
| 51 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 52 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
TL_BUS_UNIT_VW
|
| 53 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 54 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
TL_LOCATION_VW
|
| 55 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 56 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
TL_DEPT_TBL_VW
|
| 57 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 58 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
TL_JOBCODE_VW
|
| 59 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 60 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
Prompt Table:
TL_PRODUCT_TBL
|
| 61 |
CUSTOMER |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer
Prompt Table:
TL_CUSTOMER
|
| 62 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
TL_ACCTCD_BU_VW
|
| 63 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Business Unit
Prompt Table:
BUS_UNIT_PRJ_VW
|
| 64 |
BUSINESS_UNIT_PF |
Character(5) |
VARCHAR2(5) NOT NULL |
Perf Meas Business Unit
Prompt Table:
BUS_UNIT_TBL_PF
|
| 65 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
Prompt Table:
%EDIT_PROJECT
|
| 66 |
SETID_ACTIVITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity Set ID
|
| 67 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 68 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Type
Prompt Table:
TL_PROJ_RTYPE_V
|
| 69 |
SETID_RESOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Resource Set ID
|
| 70 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Category
Prompt Table:
%EDIT_RES_CAT
|
| 71 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Sub Category
Prompt Table:
%EDIT_RES_SUB
|
| 72 |
TASK |
Character(5) |
VARCHAR2(5) NOT NULL |
Task
Prompt Table:
TL_TASK
|
| 73 |
USER_FIELD_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 1
Prompt Table:
TL_USER_FIELD_1
|
| 74 |
USER_FIELD_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 2
Prompt Table:
TL_USER_FIELD_2
|
| 75 |
USER_FIELD_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 3
Prompt Table:
TL_USER_FIELD_3
|
| 76 |
USER_FIELD_4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 4
Prompt Table:
TL_USER_FIELD_4
|
| 77 |
USER_FIELD_5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 5
Prompt Table:
TL_USER_FIELD_5
|
| 78 |
TL_RULE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Rule ID
|
| 79 |
ORIG_TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Time Rptg Cd
|
| 80 |
ORIG_TL_QTY |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Original TL Quantity used in rules processing.
|
| 81 |
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
|
| 82 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
|
| 83 |
ORIG_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Original Sequence Number
|
| 84 |
INITIAL_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Original sequence number of payable time row.
|
| 85 |
AE_PRODUCT |
Character(2) |
VARCHAR2(2) NOT NULL |
Product
AE=PS/AE
AM=PS/AM
AP=PS/AP
AR=PS/AR
BI=PS/BI
EO=PS/EO
EX=PS/EX
FS=PS/FS
GL=PS/GL
HR=PS/HR
IN=PS/IN
OM=PS/OM
PC=PS/PC
PO=PS/PO
TR=PS/TR
|
| 86 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 87 |
AE_STEP |
Character(8) |
VARCHAR2(8) NOT NULL |
Name
|
| 88 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 89 |
END_DT |
Date(10) |
DATE |
end date
|
| 90 |
SEQ_NBR1 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 91 |
PIN_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Element Name field
|
| 92 |
EXISTS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Flag tells if we should use Exists, or Not Exists as a predicate prefixing the SubQuery.
0=Exists
1=Not Exists
|
| 93 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 94 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 95 |
SRC_CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Calendar ID
|
| 96 |
PI_VER_NUM |
Number(3,0) |
SMALLINT NOT NULL |
PI version number
|
| 97 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 98 |
PI_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Input Source
A=Absence
G=Generated PI
M=Manual
T=Time&Labor
|
| 99 |
GEN_INSTANCE |
Number(4,0) |
SMALLINT NOT NULL |
Instance of Generated PI
|
| 100 |
SRC_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Calendar Run ID
|