| # |
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
|