SFA_AWD_INST_VW(SQL View) |
Index Back |
---|---|
Award Instance Employee ViewView 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 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution | |
3 | Character(4) | VARCHAR2(4) NOT NULL | Aid Year | |
4 | 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. |