| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_COUNTRY_VW
Set Control Field: COUNTRY
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
ENTLMNT_ACCRUAL_PD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the entitlement's accrual period.
Y/N Table Edit
Default Value: N
|
| 5 |
ACC_FROM_DATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to display the from date for the entitlement's accrual period
Y/N Table Edit
Default Value: N
|
| 6 |
ACC_TO_DATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to display the To Date of the entitlement's accrual period.
Y/N Table Edit
Default Value: N
|
| 7 |
TAKE_UK1_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to display user key 1 of the entitlement.
Y/N Table Edit
Default Value: N
|
| 8 |
TAKE_UK2_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to display user key 2 of the entitlement.
Y/N Table Edit
Default Value: N
|
| 9 |
TAKE_UK3_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to display user key 3 of the entitlement.
Y/N Table Edit
Default Value: N
|
| 10 |
TAKE_UK4_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to display user key 4 of the entitlement.
Y/N Table Edit
Default Value: N
|
| 11 |
TAKE_UK5_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to display user key 5 of the entitlement.
Y/N Table Edit
Default Value: N
|
| 12 |
TAKE_UK6_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to display user key 6 of the entitlement.
Y/N Table Edit
Default Value: N
|
| 13 |
LEAVE_HIST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This fields indicates wheter the Leave History Transactions are allowed in the Self Service Absences Pages
N=No
Y=Yes
Default Value: N
|
| 14 |
DFLT_HIST_DT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to display the remaining history date range default fields in the configuration.
Y/N Table Edit
Default Value: Y
|
| 15 |
DAYS_BEFORE |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to indicate how many days before the current date to show the history date range.
Default Value: 90
|
| 16 |
DAYS_AFTER |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to indicate how many days after the current date to show the end of the history date range.
Default Value: 90
|
| 17 |
REQUESTED_BY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the requested by column in the history grid.
Y/N Table Edit
Default Value: N
|
| 18 |
DURATION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display duration.
Y/N Table Edit
Default Value: N
|
| 19 |
FCST_BAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not Forecasting Balances is available.
Y/N Table Edit
Default Value: N
|
| 20 |
FCST_REQ_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether Forecasting a request is enabled.
Y/N Table Edit
Default Value: N
|
| 21 |
FCST_FROM_DT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the from date in the forecasting results grid.
Y/N Table Edit
Default Value: N
|
| 22 |
FCST_TO_DT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the To Date in the forecasting results grid.
Y/N Table Edit
Default Value: N
|
| 23 |
FCST_UK1_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the forecasting user key 1 in the forecasting results grid.
Y/N Table Edit
Default Value: N
|
| 24 |
FCST_UK2_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the forecasting user key 2 in the forecasting results grid.
Y/N Table Edit
Default Value: N
|
| 25 |
FCST_UK3_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the forecasting user key 3 in the forecasting results grid.
Y/N Table Edit
Default Value: N
|
| 26 |
FCST_UK4_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the forecasting user key 4 in the forecasting results grid.
Y/N Table Edit
Default Value: N
|
| 27 |
FCST_UK5_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the forecasting user key 5 in the forecasting results grid.
Y/N Table Edit
Default Value: N
|
| 28 |
FCST_UK6_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the forecasting user key 6 in the forecasting results grid.
Y/N Table Edit
Default Value: N
|
| 29 |
DELETE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Event option
1=All Events
2=All Events Except Processed
3=All Events Except Finalized
Default Value: 1
|
| 30 |
HGA_CAN_LIMIT_BACK |
Number(4,0) |
SMALLINT NOT NULL |
Cancel limit by Months backward
|
| 31 |
HGA_CAN_LIMIT_FWD |
Number(4,0) |
SMALLINT NOT NULL |
Cancel limit by months forward
|
| 32 |
ALLOW_TIME_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to capture the setup data at country and country take on whether the Start and End Time had to be captured
Y/N Table Edit
Default Value: N
|
| 33 |
ABSENCE_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
07/29/13 EGS: Created
Y/N Table Edit
Default Value: N
|
| 34 |
SAVE_FOR_LATER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Save For Later Option
A=Always Validate
B=Never Validate
N=Save For Later Is Not Allowed
U=Use User Preference
Y=Prompt For Validation
Y/N Table Edit
Default Value: N
|
| 35 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
HGA_PACKAGE_VW
|
| 36 |
APPCLASS_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table:
HGA_APCLSPTH_VW
|
| 37 |
ABS_BALANCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Absence Balance optoins
F=Last Finalized Period
P=Last Processed Period
Default Value: F
|
| 38 |
BAL_INFO_FCST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Absence Balance information forecast indicator
Default Value: N
|
| 39 |
EARNED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Earned flag
Default Value: Y
|
| 40 |
TAKEN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Take Flag
Default Value: Y
|
| 41 |
ADJ_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment
Default Value: Y
|
| 42 |
OPENING_BAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Opening Balance Flag
Default Value: Y
|
| 43 |
DISP_PROC_DTL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Absence Processing Information
Default Value: N
|