GP_ABS_TMPL_SCH (SQL View)	Index Back
Template Configuration table Configurable Sections: The Template Configuration table is a single child of the Template Header Table, and will store template configuration fields.

GP_ABS_TMPL_SCH

(SQL View)

Template Configuration table

Configurable Sections: The Template Configuration table is a single child of the Template Header Table, and will store template configuration fields.

SELECT A.COUNTRY , A.GP_ABS_CS_TMPL_ID , A.DESCR50 , A.GP_ABS_CS_TMPLSTAT , 'EMP' , C.XLATLONGNAME FROM PS_GP_ABS_TMPL_HDR A , PSXLATITEM C WHERE A.EFFDT = ( SELECT MAX (A1.EFFDT) FROM PS_GP_ABS_TMPL_HDR A1 WHERE A1.COUNTRY = A.COUNTRY AND A1.GP_ABS_CS_TMPL_ID = A.GP_ABS_CS_TMPL_ID) AND C.FIELDNAME = 'GP_ABS_CS_PER_ORG' AND C.FIELDVALUE = 'EMP' AND %EffdtCheck(PSXLATITEM C1, C, A.EFFDT)

Parent record: GP_ABS_TMPL_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: GP_COUNTRY_VW

2 GP_ABS_CS_TMPL_ID Character(18) VARCHAR2(18) NOT NULL Template ID or Template Section Configuration ID. Used by EA to create templates that are used by Absence requests.

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

4 GP_ABS_CS_TMPLSTAT Character(1) VARCHAR2(1) NOT NULL Configurable Sections Setup: Template Status
A=Active
I=Inactive
T=Test

5 GP_ABS_CS_PER_ORG Character(3) VARCHAR2(3) NOT NULL Configurables Sections Setup: Organizational Relationship
CWR=Contingent Worker
EMP=Employee
Default Value: EMP

6 PER_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Description for the PER_ORG field.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRY_VW
2	GP_ABS_CS_TMPL_ID	Character(18)	VARCHAR2(18) NOT NULL	Template ID or Template Section Configuration ID. Used by EA to create templates that are used by Absence requests.
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
4	GP_ABS_CS_TMPLSTAT	Character(1)	VARCHAR2(1) NOT NULL	Configurable Sections Setup: Template Status A=Active I=Inactive T=Test
5	GP_ABS_CS_PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Configurables Sections Setup: Organizational Relationship CWR=Contingent Worker EMP=Employee Default Value: EMP
6	PER_ORG_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description for the PER_ORG field.