SFA_STU_NNFTI_V

(SQL View)
 Index Back

Non FTI Fields View


SELECT 1 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_PEN_ROLL1' UNION SELECT 2 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_IRA_ROLL1' UNION SELECT 3 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_GRANT_AID' UNION SELECT 4 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_FED_TAX1' UNION SELECT 5 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_CHILD_SUP_RECV' UNION SELECT 6 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'CASH_SAVINGS' AND LABEL_ID = 'CASH_SAVINGS_11' UNION SELECT 7 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'BUS_NET_WORTH' AND LABEL_ID = 'BUS_NET_WORTH_2' UNION SELECT 8 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'INV_NET_WORTH' AND LABEL_ID = 'INV_NET_WORTH_2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
4 SFA_STD_FTI_DTA Character(30) VARCHAR2(30) NOT NULL Student FTI Data