| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
BGN_DT |
Date(10) |
DATE NOT NULL |
Begin Date
|
| 4 |
PIN_TAKE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Absence Take
Prompt Table:
GP_PIN_ABSTK_VW
|
| 5 |
END_DT |
Date(10) |
DATE |
end date
|
| 6 |
ORIG_BEGIN_DT |
Date(10) |
DATE |
original begin date
Default Value: GP_ABS_EVENT.BGN_DT
|
| 7 |
ABS_ENTRY_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Absence Entry Source
1=Administrator Absence Event
2=Time & Labor
3=Third Party
4=Employee Absence Request
5=Manager Absence Request
6=Employee Timesheet
7=Manager Timesheet
A=Employee Extended Absence
B=Manager Extended Absence
C=Administrator Extended Absence
D=Employee Desktop Integration
Default Value: 1
|
| 8 |
PRC_EVT_ACTN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Action Event Indicator
N=Normal
V=Void
Default Value: N
|
| 9 |
VOIDED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Voided Indicator
Y/N Table Edit
Default Value: N
|
| 10 |
ABSENCE_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
absence reason
Prompt Table:
%GP_EDIT_FLD1
|
| 11 |
BEGIN_DAY_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Partial Hours
|
| 12 |
BEGIN_DAY_HALF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
indicates whether first day of an absence event began counts as half a day
Y/N Table Edit
Default Value: N
|
| 13 |
END_DAY_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
partial hours end
|
| 14 |
END_DAY_HALF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
half day end indicator
Y/N Table Edit
Default Value: N
|
| 15 |
ALL_DAYS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
All Days Indicator
N=Apply To Begin Day Only
Y=Apply To All Days
Default Value: N
|
| 16 |
MANAGER_APPR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Manager Approved
Y/N Table Edit
Default Value: N
|
| 17 |
OVRD_ENT_VAL |
Signed Number(12,6) |
DECIMAL(10,6) NOT NULL |
Override Entitlement Amoung
|
| 18 |
OVRD_ADJ_VAL |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Override Adjustment Amoung
|
| 19 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 20 |
PYE_RUN_NUM |
Number(8,0) |
INTEGER NOT NULL |
Number to link to Payee Run Table
|
| 21 |
LAST_UPDT_DT |
Date(10) |
DATE |
Date of last Update
|
| 22 |
PROCESS_DT |
Date(10) |
DATE |
Process Date
|
| 23 |
ABS_EVT_FCST_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used on the GP_ABS_EVENT record to record the value of the resolved related forecast element.
|
| 24 |
FCST_DTTM |
DateTime(26) |
TIMESTAMP |
This field is used on the GP_ABS_EVENT to record the last time forecasting was run for this event.
|
| 25 |
DURATION_ABS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration field containing 2 decimals to handle absence requirements
|
| 26 |
DURATION_HRS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration Hrs
|
| 27 |
DURATION_DYS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration field containing 2 decimals to handle absence requirements
|
| 28 |
ACTION_DT_SS |
Date(10) |
DATE |
Date Submitted
|
| 29 |
WF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
|
| 30 |
TRANSACTION_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
|
| 31 |
TRANSACTION_NBR_EA |
Number(15,0) |
DECIMAL(15) NOT NULL |
The Extendned Absence transaction number
Default Value: 0
|
| 32 |
FIRST_PROC_DT |
Date(10) |
DATE |
GP Core/Abs Mgt field to track when an absence was first processed. This date will not change regardless of how many retro runs are run against the absence subsequent to the initial calculation.
|
| 33 |
COMMENT1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Comments
|
| 34 |
USED_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries
C=Specific Country
|
| 35 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 36 |
ABS_TYPE_OPTN |
Character(3) |
VARCHAR2(3) NOT NULL |
Absence Type
|
| 37 |
GP_ABS_EVT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Absence event status
F=Finalized
N=Not Processed
P=Processed
|
| 38 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 39 |
CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Calendar Year
|
| 40 |
ABS_PARTIAL_DAYS |
Character(3) |
VARCHAR2(3) NOT NULL |
Partial Days Indicator
ADH=All Day Half
ALL=All Day
BD=Begin Day Hours
BDH=Begin Day Half
BE=Begin and Day Hours
BEH=Begin and End days Half
ED=End Day Hours
EDH=End Day Half
|
| 41 |
ABS_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Absence Category
A=Approved
O=Other
P=Planned
|
| 42 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 43 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 44 |
PRD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Period Type
C=Current
R=Retro
|
| 45 |
FISCAL_QUARTER |
Character(2) |
VARCHAR2(2) NOT NULL |
Fiscal Quarter
|
| 46 |
CALENDAR_QUARTER |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar Quarter
|
| 47 |
UNIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days
H=Hours
|
| 48 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 49 |
TRANSACTION_NBR_AT |
Number(15,0) |
DECIMAL(15) NOT NULL |
This field is created to support the Attachments on Request Absence Fluid page
|
| 50 |
EOAWSTEP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
|
| 51 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 52 |
EOAWDTTM_MODIFIED |
DateTime(26) |
TIMESTAMP |
Datetime modified
|
| 53 |
DTTM_MODIFIED |
DateTime(26) |
TIMESTAMP |
Datetime modified
|
| 54 |
DTTM_CREATED |
DateTime(26) |
TIMESTAMP |
Datetime Created
|
| 55 |
EOAWUSTEP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approver Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=Hold
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
S=Skipped
T=Terminated
U=Auto approved
W=Canceled
X=Deleted
Y=Bypassed
|
| 56 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 57 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
|
| 58 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
|
| 59 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 60 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 61 |
LASTUPDDTTM_J |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 62 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 63 |
DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Daily Rate
|
| 64 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 65 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 66 |
HR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Status
A=Active
I=Inactive
|
| 67 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
Reports To Position Number
|
| 68 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 69 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 70 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 71 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 72 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 73 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 74 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 75 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 76 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 77 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 78 |
EMPLID_CURR_APPR |
Character(11) |
VARCHAR2(11) NOT NULL |
Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.
|
| 79 |
COUNTRY2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|