GPDE_CT_FLD_VW (SQL View)	Index Back
CT Form Fields Table Holds fields as defined on a certificate template form The content of this table is generated automatically on the setup forms details page

GPDE_CT_FLD_VW

(SQL View)

CT Form Fields Table

Holds fields as defined on a certificate template form The content of this table is generated automatically on the setup forms details page

SELECT GPDE_FM_FORM_ID , EFFDT , GPDE_FM_FLD_NAME FROM PS_GPDE_FM_FLD WHERE GPDE_FM_LANG_CD = 'GER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPDE_FM_FORM_ID Character(12) VARCHAR2(12) NOT NULL ID of PDF Form

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 GPDE_FM_FLD_NAME Character(254) VARCHAR2(254) NOT NULL Form Field Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPDE_FM_FORM_ID	Character(12)	VARCHAR2(12) NOT NULL	ID of PDF Form
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	GPDE_FM_FLD_NAME	Character(254)	VARCHAR2(254) NOT NULL	Form Field Name