HGA_COTK_VW (SQL View)	Index Back
Country Take View Country Take View. this is used to prompt user while picking eligible absence takes from chatbot

HGA_COTK_VW

(SQL View)

Country Take View

Country Take View. this is used to prompt user while picking eligible absence takes from chatbot

SELECT SS.COUNTRY , SS.PIN_TAKE_NUM , SS.EFFDT , PIN.DESCR , SS.ALLOW_EA_ENTRY , SS.EFF_STATUS , SS.FCST_IND , SS.FCST_REQ_SUBMIT , SS.FCST_REQ_SBMT_ROLE , SS.ALLOW_PARTIAL_DAYS , SS.PARTIAL_DAYS_OPTN FROM PS_GP_PIN PIN , PS_GP_ABS_SS SS WHERE SS.PIN_TAKE_NUM=PIN.PIN_NUM

Related Language Record: HGA_COTK_LV

# 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

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 ALLOW_EA_ENTRY Character(1) VARCHAR2(1) NOT NULL Used to capture the setup data at country take on whether a take can be entered as an Extended Absence

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

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

8 FCST_REQ_SUBMIT Character(1) VARCHAR2(1) NOT NULL This field indicates whether Forecasting is required to submit an absence request.

9 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

10 ALLOW_PARTIAL_DAYS Character(1) VARCHAR2(1) NOT NULL This field indicates whether partial days are allowed for a particular absence take

11 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

#	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
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	ALLOW_EA_ENTRY	Character(1)	VARCHAR2(1) NOT NULL	Used to capture the setup data at country take on whether a take can be entered as an Extended Absence
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
7	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.
8	FCST_REQ_SUBMIT	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether Forecasting is required to submit an absence request.
9	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
10	ALLOW_PARTIAL_DAYS	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether partial days are allowed for a particular absence take
11	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