GPFR_LT_COMP_S (SQL View)	Index Back
ATILL: Used as prompt table ATILL: Used as prompt table. dedicated to retrieve companies from LT record. Process of selection of the employees who deserve the LT Certificate.

GPFR_LT_COMP_S

(SQL View)

ATILL: Used as prompt table

ATILL: Used as prompt table. dedicated to retrieve companies from LT record. Process of selection of the employees who deserve the LT Certificate.

SELECT DISTINCT(A.COMPANY) , SEC.ROWSECCLASS FROM PS_GPFR_ILL_ADMIN A , PS_GPFR_ILL_LONG B , PS_GP_ABS_EVENT C %Sql(GPFR_SECU_EMPLMT_SQL, C) AND A.EMPLID = B.EMPLID AND C.EMPLID = B.EMPLID AND A.ORIG_BEGIN_DT = B.ORIG_BEGIN_DT AND A.GB_GROUP_ID = B.GB_GROUP_ID AND B.GPFR_ILL_LONG_TERM = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security