SFA_AWD_INST_VW

(SQL View)
Index Back

Award Instance Employee View

View of Financial Aid Award Notification Letter Forms Engine Instances by employee identifier.

SELECT %Substring(B.FORM_FIELD_C040 ,1 ,11) ,D.INSTITUTION ,F.AID_YEAR ,A.FORM_PROC_INST ,B.FORM_GROUP_SEQ FROM PS_FA_AWD_INST_VW A ,PS_FORM_DATA B ,PS_FORM_DATA C ,PS_INSTITUTION_TBL D ,PS_FORM_DATA E ,PS_AID_YEAR_TBL F WHERE B.FORM_PROC_INST = A.FORM_PROC_INST AND B.FORM_FIELD_NAME = 'ID' AND B.FORM_GROUP_SUB_SEQ = 1 AND C.FORM_PROC_INST = B.FORM_PROC_INST AND C.FORM_GROUP_SEQ = B.FORM_GROUP_SEQ AND C.FORM_GROUP_SUB_SEQ = B.FORM_GROUP_SUB_SEQ AND C.FORM_FIELD_NAME = 'INST_NAME' AND D.DESCR = %Substring(C.FORM_FIELD_C040,1,30) AND D.EFFDT = ( SELECT MAX(D2.EFFDT) FROM PS_INSTITUTION_TBL D2 WHERE D2.INSTITUTION = D.INSTITUTION AND D2.EFFDT <= %CurrentDateIn ) AND E.FORM_PROC_INST = C.FORM_PROC_INST AND E.FORM_GROUP_SEQ = C.FORM_GROUP_SEQ AND E.FORM_GROUP_SUB_SEQ = C.FORM_GROUP_SUB_SEQ AND E.FORM_FIELD_NAME = 'AID_YEAR_DESCR' AND F.INSTITUTION = D.INSTITUTION AND F.DESCR = %Substring(E.FORM_FIELD_C040,1,30)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
4 FORM_PROC_INST Number(31,0) DECIMAL(31) NOT NULL Form Process Instance collects one or more input jobs (or process instances) into a single output collection for processing. Typically, one form process instance is one batch of output to be printed together.
5 FORM_GROUP_SEQ Number(9,0) DECIMAL(9) NOT NULL Form Group Sequence enables the sequencing of form groups within a FORM_PROC_INST. Each time a group of forms begins to print, this value is incremented and stays the same within that form group. If the same form group prints again, it is incremented again, so that it is not the same value if the same form group prints twice.