GPDE_FM_FLD

(SQL Table)
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

# 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

Default Value: %date

3 GPDE_FM_LANG_CD Character(3) VARCHAR2(3) NOT NULL language code of Form

Prompt Table: LANGUAGE_CD_VW

4 GPDE_FM_FLD_NBR Number(4,0) SMALLINT NOT NULL Form Field Number
5 GPDE_FM_FLD_NAME Character(254) VARCHAR2(254) NOT NULL Form Field Name
6 GPDE_FM_FLD_TYPE Character(1) VARCHAR2(1) NOT NULL Form Field Type (Text, CheckBox, List etc) comes from PDF Form itself
B=Button
C=Check Box
T=Text
7 GPDE_FM_XML_TAG Character(254) VARCHAR2(254) NOT NULL XML tag that should be used to create XML stream for Certificates
8 GPDE_CT_FIELDTYPE Character(1) VARCHAR2(1) NOT NULL Field type of entered Field (char, date, num etc)
0=Character
1=Long Character
2=Number
3=Signed Number
4=Date
5=Time
6=Datetime
7=Y/N Field

Default Value: 0