GM_EC_AWD02(SQL View) |
Index Back |
|---|---|
EDI Organization ID |
| SELECT DISTINCT B.SETID , B.INSTID , C.ORG_LEG_NAME , B.FEDERAL_EIN_GM , B.ACCOUNTING_BASIS FROM PS_GM_AWARD A , PS_GM_IN_INFO B , PS_GM_INSTITUTION C WHERE B.SETID=( SELECT SETID FROM PS_SET_CNTRL_REC G WHERE G.SETCNTRLVALUE=A.BUSINESS_UNIT AND G.RECNAME='GM_IN_INFO') AND B.EFFDT=( SELECT MAX(E.EFFDT) FROM PS_GM_IN_INFO E WHERE E.SETID = B.SETID AND E.INSTID = B.INSTID AND E.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND C.SETID=B.SETID AND C.INSTID=B.INSTID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | INSTID | Character(5) | VARCHAR2(5) NOT NULL | Institution ID |
| 3 | ORG_LEG_NAME | Character(60) | VARCHAR2(60) NOT NULL | Organization Legal Name |
| 4 | FEDERAL_EIN_GM | Character(30) | VARCHAR2(30) NOT NULL | Federal EIN |
| 5 | ACCOUNTING_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Basis
A=Accrual C=Cash |