SCCPU_FATRM_BND

(SQL View)
 Index Back

Bind for STDNT_FA_TERM

This table hosts required fields for updating STDNT_FA_TERM for Population Update.

SELECT A.EMPLID ,A.INSTITUTION ,A.STRM ,A.EFFDT ,A.EFFSEQ ,B.NAME ,C.DESCR FROM PS_STDNT_FA_TERM A , PS_SCC_PRI_NAME_VW B ,PS_TERM_VAL_TBL C WHERE A.EFFDT=( SELECT MAX (A1.EFFDT) FROM PS_STDNT_FA_TERM A1 WHERE A.EMPLID=A1.EMPLID AND A.INSTITUTION=A1.INSTITUTION AND A.STRM =A1.STRM AND A1.EFFDT <=%CurrentDateIn) AND A.EFFSEQ=( SELECT MAX(A2.EFFSEQ) FROM PS_STDNT_FA_TERM A2 WHERE A.EMPLID=A2.EMPLID AND A.INSTITUTION=A2.INSTITUTION AND A.STRM =A2.STRM AND A.EFFDT =A2.EFFDT) AND A.EMPLID = B.EMPLID AND A.STRM=C.STRM

  • Related Language Record: SCCPU_FATRM_LAN

  • Parent record: FA_FATERM_PARNT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description