FORM_TYPELANGUAGE_CDFORM_TYPE_LVW(SQL View) |
Index Back |
|---|---|
Form Type ViewForm Type View |
| SELECT a.form_type ,b.language_cd ,b.portal_label ,b.portal_label ,a.form_owner_id FROM PS_FORM_TYPE a , PS_FORM_TYPE_lg b , PSPRSMDEFNLANG c WHERE a.form_type = b.form_type AND c.portal_objname = a.portal_objname AND c.language_cd = b.language_cd AND c.PORTAL_REFTYPE = 'F' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORM_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Form and Builder Field |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 4 | PORTAL_LABEL1 | Character(30) | VARCHAR2(30) NOT NULL | Label 1 |
| 5 | FORM_OWNER_ID | Character(30) | VARCHAR2(30) NOT NULL | Owner Id |