AM_CGU_FIELD

(SQL View)
 Index Back

SQL View for All active CFs


SELECT DISTINCT A.FIELDNAME , A.LONGNAME , C.PROMPT_TBL , C.PROMPT_TBL2 , C.PROMPT_TBL3 FROM PS_FS_FLD_PROMPT C , PSDBFLDLABL A , PS_FS_CF_TEMPLATE B WHERE A.FIELDNAME = B.FIELDNAME AND A.DEFAULT_LABEL = 1 AND (B.CF_TYPE = 'F' OR A.FIELDNAME IN ('DEPTID', 'PROJECT_ID')) AND B.CF_ACTIVE_STATUS = 'A' AND C.FIELDNAME = A.FIELDNAME UNION SELECT DISTINCT A.FIELDNAME , A.LONGNAME , C.PROMPT_TBL , C.PROMPT_TBL2 , C.PROMPT_TBL3 FROM PS_FS_FLD_PROMPT C , PSDBFLDLABL A WHERE A.FIELDNAME = C.FIELDNAME AND A.FIELDNAME = 'CATEGORY' AND A.DEFAULT_LABEL = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
3 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table
4 PROMPT_TBL2 Character(15) VARCHAR2(15) NOT NULL Prompt Table 2
5 PROMPT_TBL3 Character(15) VARCHAR2(15) NOT NULL Prompt Table 3