GM_EC_AWD04(SQL View) |
Index Back |
|---|---|
EDI Organization F&A |
| SELECT DISTINCT B.SETID, B.INSTID, B.FA_NEG_RT_STAT FROM PS_GM_AWARD A, PS_GM_IN_FA_AGRMT B WHERE B.SETID=(SELECT SETID FROM PS_SET_CNTRL_REC G WHERE G.SETCNTRLVALUE=A.BUSINESS_UNIT AND G.RECNAME='GM_IN_FA_AGRMT') AND B.EFFDT=(SELECT MAX(E.EFFDT) FROM PS_GM_IN_FA_AGRMT E WHERE E.SETID = B.SETID AND E.INSTID = B.INSTID AND E.EFFDT <= %CURRENTDATEIN) AND B.EFF_STATUS = 'A' |
| # | 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 | FA_NEG_RT_STAT | Character(4) | VARCHAR2(4) NOT NULL |
Rate Negotiation Status
FINL=Final FIXD=Fixed PRED=Pre-determined PROV=Provisional |