SETIDCHG_GRP_CDLANGUAGE_CDRE_OPEX_CLS_VW(SQL View) |
Index Back |
|---|---|
OpEx Charge Codes |
| SELECT A.SETID , A.CHG_GRP_CD , L.LANGUAGE_CD ,L.INSTANCE_NAME , L.INSTANCE_DESCR FROM PS_RE_EXP_CLS A , PS_RE_EXPCLS_LG L WHERE A.END_EFFDT >= %CurrentDateIn AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_RE_EXP_CLS B WHERE B.SETID = A.SETID AND B.CHG_GRP_CD = A.CHG_GRP_CD AND B.EFFDT <= %CurrentDateIn) AND L.SETID = A.SETID AND L.CHG_GRP_CD = A.CHG_GRP_CD AND L.TXN_GRP = A.TXN_GRP AND L.EFFDT = A.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CHG_GRP_CD |
Character(10) | VARCHAR2(10) NOT NULL | This field holds the Charge Group Code for the Transaction Groups. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | INSTANCE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Instance Name |
| 5 | INSTANCE_DESCR | Character(150) | VARCHAR2(150) NOT NULL | Generic Description Field for Instances of Generic Entities |