SRVC_IND_FA_VW

(SQL View)
 Index Back

Fin Aid Service Indicators

Service indicators are activated for a person on this record. Service indicators indicate whether to block,limit or provide preferential services to a person.

SELECT A.Emplid ,A.Srvc_Ind_Act_Term FROM PS_SRVC_IND_DATA A WHERE A.Srvc_Ind_Act_Term = ( SELECT MIN(Srvc_Ind_Act_Term) FROM PS_SRVC_IND_DATA B WHERE A.Emplid = B.Emplid AND A.Srvc_Ind_Dttm = B.Srvc_Ind_Dttm AND B.Srvc_ind_Cd = 'FA1' )

  • Parent record: PERSON

  • Audit Record: AUDIT_SRVC_IND

    • # 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 STRM Character(4) VARCHAR2(4) NOT NULL Term