SRVC_IND_FA_VW(SQL View) |
Index Back |
---|---|
Fin Aid Service IndicatorsService 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' ) |
# | 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 |