GP_NRP_ASS_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
2	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_AT0_VW
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
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
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
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: N
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.
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
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
26	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.
27	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.
28	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
29	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.
30	REASON_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether the Reason field is required.
31	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
32	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
33	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.
34	FCST_REQ_SUBMIT	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether Forecasting is required to submit an absence request.
35	FCST_REQ_APPROVAL	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether Forecasting is required to approve an absence request.
36	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
37	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
38	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
39	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.
40	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
41	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
42	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
43	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: Y
44	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
45	PTAFPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
46	PTAFDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Definition ID
47	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
48	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.
49	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
50	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
51	OVERRIDE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Override Flag 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