| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_CNTRY_OP_VW
|
| 2 |
PIN_TAKE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Absence Take
Prompt Table:
GP_ABS_SS_ADD
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
UNIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days
H=Hours
Default Value: D
|
| 6 |
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
|
| 7 |
REQUEST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This fields indicates if the country is allowed to add new Leave Request in the Self Service Absences Pages
N=No
Y=Yes
Default Value: N
|
| 8 |
CALC_END_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
This fields indicates if the end date will be calculated in the Self Service absence entry page
N=No
Y=Yes
Default Value: Y
|
| 9 |
EXCL_HOLIDAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
This fields indicates if the end date calculation needs to substract holidays
N=No
Y=Yes
Default Value: N
|
| 10 |
EXCL_NON_WORK |
Character(1) |
VARCHAR2(1) NOT NULL |
This fields indicates if the end date calculation needs to substract days off
N=No
Y=Yes
Default Value: N
|
| 11 |
DISP_USER_FIELDS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether or not to display the user fields in the entitlement.
Y/N Table Edit
Default Value: N
|
| 12 |
ABS_USER_FLD1_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
User Field 1-Label, this label will be displayed in the Self Service Absences Transactions Pages
|
| 13 |
ABS_USER_FLD2_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
User Field 2-Label, this label will be displayed in the Self Service Absences Transactions Pages
|
| 14 |
ABS_USER_FLD3_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
User Field 3-Label, this label will be displayed in the Self Service Absences Transactions Pages
|
| 15 |
ABS_USER_FLD4_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
User Field 4-Label, this label will be displayed in the Self Service Absences Transactions Pages
|
| 16 |
REQUIRED_CONFIG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the user field is required
N=No
Y=Yes
Default Value: N
|
| 17 |
REQUIRED_CONFIG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the user field is required
N=No
Y=Yes
Default Value: N
|
| 18 |
REQUIRED_CONFIG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the user field is required
N=No
Y=Yes
Default Value: N
|
| 19 |
REQUIRED_CONFIG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the user field is required
N=No
Y=Yes
Default Value: N
|
| 20 |
FLD_FMT_CONFIG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 1 Format
1=Character
2=Date
3=Monetary
4=Decimal
|
| 21 |
FLD_FMT_CONFIG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 2 Format
1=Character
2=Date
3=Monetary
4=Decimal
|
| 22 |
FLD_FMT_CONFIG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 3 Format
1=Character
2=Date
3=Monetary
4=Decimal
|
| 23 |
FLD_FMT_CONFIG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 4 Format
1=Character
2=Date
3=Monetary
4=Decimal
|
| 24 |
DISPLAY_ORDER |
Number(3,0) |
SMALLINT NOT NULL |
Display order for ordering items in a list - web style
Default Value: 999
|
| 25 |
RQST_ALLOWED_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
This field dictates who can request a specific absence take in self-service.
B=Employee and Manager
E=Employee
M=Manager
Default Value: B
|
| 26 |
REQUEST_AS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field dictates if the manager can request an absence take as an employee in self-service.
E=Employee
M=Manager
N=Not Applicable
Default Value: E
|
| 27 |
OVERRIDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Flag
Y/N Table Edit
Default Value: Y
|
| 28 |
DISP_CURR_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not to show the current balance of the entitlement on the self-service pages.
Y/N Table Edit
Default Value: N
|
| 29 |
CURR_BAL_ACCUM |
Number(8,0) |
INTEGER NOT NULL |
This field is used to contain the pin number of the accumulator that will represent the current balance of the entitlements.
Prompt Table:
GP_PIN_AC0_VW
|
| 30 |
BAL_ACCUM_DISP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will dictate how the current balance will be calculated and displayed on the self-service pages.
N=Not Summarized
S=Summarized
Default Value: N
|
| 31 |
DISPLAY_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to determine whether the Absence Reason field should display on the self-service pages.
Y/N Table Edit
Default Value: Y
|
| 32 |
REASON_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether the Reason field is required.
Y/N Table Edit
Default Value: N
|
| 33 |
ALLOW_PARTIAL_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether partial days are allowed for a particular absence take
Y/N Table Edit
Default Value: N
|
| 34 |
PARTIAL_DAYS_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will be used to indicate what types of partial days are allowed
B=Partial Hours and Half Days
D=Half Days
H=Partial Hours
N=None
Default Value: N
|
| 35 |
FCST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used on the GP_PIN record to indicate whether or not the element should be processed during Forecasting.
Y/N Table Edit
Default Value: N
|
| 36 |
FCST_REQ_SUBMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether Forecasting is required to submit an absence request.
Y/N Table Edit
Default Value: N
|
| 37 |
FCST_REQ_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether Forecasting is required to approve an absence request.
Y/N Table Edit
Default Value: N
|
| 38 |
FCST_REQ_SBMT_ROLE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates which role is required to Forecast in order to submit an absence request.
B=Employee and Manager
E=Employee
M=Manager
N=Not Applicable
Default Value: N
|
| 39 |
FCST_REQ_APPR_ROLE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates which role is required to Forecast in order to approve the absence request.
A=Administrator
B=Administrator and Manager
M=Manager
N=Not Applicable
Default Value: N
|
| 40 |
FCST_MESSAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate which type of Forecasting message to use as a result of Forecasting being complete, default message or a customized message.
C=Customized Message
D=Default Message
Default Value: D
|
| 41 |
SUBMIT_WITH_WARN |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether a request can be submitted after Forecasting returns a warning message.
Y/N Table Edit
Default Value: N
|
| 42 |
SUBMIT_WITH_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether an absence request can be submitted after Forecasting returns an error message
Y/N Table Edit
Default Value: N
|
| 43 |
WARN_SUBMT_BY_ROLE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate which role is allowed to submit an absence request that has a warning returned by Forecasting.
B=Employee and Manager
E=Employee
M=Manager
N=Not Applicable
Default Value: N
|
| 44 |
ERR_SUBMT_BY_ROLE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate which role is allowed to approve an absence request that had an error returned after Forecasting is complete.
A=Administrator
B=Employee and Manager
E=Employee
M=Manager
N=Not Applicable
Default Value: N
|
| 45 |
CALC_DURATION |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether to calculate the end date, the duration, or both.
Y/N Table Edit
Default Value: N
|
| 46 |
END_DT_DURATN_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate what rule to apply when both fields (end date and calculation) are available. Which takes field will be calculated if fields have values.
D=Duration
E=End Date
N=Not Applicable
Default Value: N
|
| 47 |
PTAFPRCS_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table:
GP_ABS_AWPR_VW1
|
| 48 |
PTAFDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Definition ID
Prompt Table:
GP_ABS_AWPR_VW2
|
| 49 |
CANCEL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate what to do with the physical absence record when it is being canceled.
C=Change Status on Record
D=Delete From Database
Default Value: C
|
| 50 |
START_END_HOL_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether the start or end date of an absence request can be scheduled for a holiday.
Y/N Table Edit
Default Value: Y
|
| 51 |
START_END_OFF_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether the start or end date can be scheduled for an off-day
Y/N Table Edit
Default Value: Y
|
| 52 |
DISPLAY_ORIG_BGN_D |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to determine whether the Absence Reason field should display on the self-service pages.
Y/N Table Edit
Default Value: N
|
| 53 |
ABS_TL_ENTRY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Absence Management - T/L Entry Indicator
Y/N Table Edit
Default Value: N
|