| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AGG_UPDATE_RUNTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Aggregate Update Run Type. specifies the mode with which Aggregate Update is initiated.
AGRC=Aggregates Run Control
CREW=Crew Submit
GPAB=Global Payroll Absence Process
LUMP=Lump Submit
PTRN=Pattern Submit
ROFD=Range of Dates Submit
RURC=Rapid Update Run Control
RUSN=Rapid Update Session
|
| 3 |
ST_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Session Number
|
| 4 |
GP_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Session Number
|
| 5 |
ST_RTNCD |
Number(4,0) |
SMALLINT NOT NULL |
SubmitTime Return Code
|
| 6 |
ST_RTNCD_RSN |
Character(100) |
VARCHAR2(100) NOT NULL |
Submit Time Return Code Reason
|
| 7 |
RTIME_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Reported Time Type
E=Elapsed Time
P=Punch Time
|
| 8 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 9 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 10 |
LUMP_SUM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump Sum
N=Lump Sum Off
Y=Lump Sum On
Y/N Table Edit
Default Value: N
|
| 11 |
CREWRPTG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Crew Reporting
Y/N Table Edit
Default Value: N
|
| 12 |
PATTERN_RPTG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pattern Reporting
N=Pattern Reporting Off
Y=Pattern Reporting On
Y/N Table Edit
Default Value: N
|
| 13 |
RANGE_OF_DT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Range of Dates
N=Range of Dates Off
Y=Range of Dates On
Y/N Table Edit
Default Value: N
|
| 14 |
GP_ABSENCE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Payroll Absence Process
|
| 15 |
CALL_TA |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in the TL_AGG_MAIN_AET state record to communicate that Rules should be run after the Aggregate Update process.
0=Don't Automatically Run Rules
1=Automatically Run Rules
Y/N Table Edit
Default Value: N
|
| 16 |
SEQ_NUM5 |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 17 |
SCHEDULER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Scheduler Flag is used to tell TLAGGUPDT whether a session was submitted through the Process Scheduler or from one of the panel submit buttons.
0=No Call to Time Admin
1=Call Time Admin
|
| 18 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 19 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 20 |
PIN_TAKE_NUM_AFT |
Number(8,0) |
INTEGER NOT NULL |
Element number [PIN] field
|
| 21 |
BGN_DT_AFT |
Date(10) |
DATE |
Begin Date
|
| 22 |
END_DT_AFT |
Date(10) |
DATE |
End Date
|
| 23 |
ALL_DAYS_AFT |
Character(1) |
VARCHAR2(1) NOT NULL |
All Days
|
| 24 |
BGN_HRS_AFT |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Partial Hours
|
| 25 |
BGN_HALF_AFT |
Character(1) |
VARCHAR2(1) NOT NULL |
indicates whether first day of an absence event began counts as half a day. copy of field BEGIN_DAY_HALF_IND
|
| 26 |
END_HRS_AFT |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Partial Hours
|
| 27 |
END_HALF_AFT |
Character(1) |
VARCHAR2(1) NOT NULL |
1/2 Day
|
| 28 |
PIN_TAKE_NUM_BFR |
Number(8,0) |
INTEGER NOT NULL |
Element number [PIN] field
|
| 29 |
BGN_DT_BFR |
Date(10) |
DATE |
Begin Date
|
| 30 |
END_DT_BFR |
Date(10) |
DATE |
End Date
|
| 31 |
ALL_DAYS_BFR |
Character(1) |
VARCHAR2(1) NOT NULL |
All Days
|
| 32 |
BGN_HRS_BFR |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Partial Hours
|
| 33 |
BGN_HALF_BFR |
Character(1) |
VARCHAR2(1) NOT NULL |
indicates whether first day of an absence event began counts as half a day. copy of field BEGIN_DAY_HALF_IND
|
| 34 |
END_HRS_BFR |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Partial Hours
|
| 35 |
END_HALF_BFR |
Character(1) |
VARCHAR2(1) NOT NULL |
1/2 Day
|
| 36 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
|
| 37 |
TASK_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Profile ID
|
| 38 |
TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
|
| 39 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 40 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 41 |
EVT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Action
|
| 42 |
PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
|
| 43 |
TL_QUANTITY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This field represents the measure of Work in hrs,amount etc.,
|
| 44 |
ROW_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Row Number
|
| 45 |
TL_ADDREP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field designates whether time should be added to or replace a particular day's time.
A=Addition
C=Correction
R=Replacement
|