SF_CHRTFLD_VW

(SQL View)
 Index Back

View of Fields from psrecfield


SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B , PS_INSTALLATION_SF C WHERE A.RECNAME = 'SF_CHARTFLD_SBR' AND A.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1 AND ((A.FIELDNAME IN ('ACCOUNT','DEPTID','FUND_CODE','PROGRAM_CODE','PROJECT_ID','BUDGET_PERIOD','CLASS_FLD','AFFILIATE','BUDGET_REF','CHARTFIELD1','CHARTFIELD2','CHARTFIELD3') AND C.PUB_SEC_FIN_REL = '8.4') OR (A.FIELDNAME IN ('ACCOUNT','DEPTID','FUND_CODE','PROGRAM_CODE','PROJECT_ID','BUDGET_PERIOD','CLASS_FLD','AFFILIATE') AND C.PUB_SEC_FIN_REL = '7.5'))

# 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