SFA_STU_FTIFN_V

(SQL View)
 Index Back

FTI Fields View


SELECT 1 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_FTI' AND LABEL_ID = 'FTIM_FTI_LBL2' UNION SELECT 2 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_OTH_FTIM_IRSCD' UNION SELECT 3 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_TAXRE' UNION SELECT 4 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_STAT' UNION SELECT 5 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_AGI' UNION SELECT 6 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_NOE' UNION SELECT 7 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_NOD' UNION SELECT 8 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_TI' UNION SELECT 9 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_TAXP' UNION SELECT 10 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_EDUC' UNION SELECT 11 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_UNIRA' UNION SELECT 12 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_DEIRA' UNION SELECT 13 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_TAXEM' UNION SELECT 14 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_UNTAX' UNION SELECT 15 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_CSCHD' UNION SELECT 16 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_SCHDA' UNION SELECT 17 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_SCHDB' UNION SELECT 18 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_SCHDD' UNION SELECT 19 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_SCHDE' UNION SELECT 20 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_SCHDF' UNION SELECT 21 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_STD_FTIM_SCHDH' UNION SELECT 22 AS SEQ , FIELDNAME , LABEL_ID , LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'SFA_OTH_FTIM_FTI' AND LABEL_ID = 'FTIM_FTI_LBL2'

# 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