SETIDDROP_WAIT_ACCTITEM_TYPELANGUAGE_CDDROPWTITEMVWLNG(SQL View) |
Index Back |
|---|---|
Charge Item Type View |
| SELECT a.setid , b.account_type_sf , a.item_type ,a.language_cd , a.descr FROM ps_ITEM_TYPE_LNG a ,PS_ITEM_TYPE_TBL y , ps_item_acct_type b WHERE a.setid=b.setid AND a.item_type=b.item_type AND a.effdt=b.effdt AND a.effdt=( SELECT MAX(effdt) FROM ps_ITEM_TYPE_LNG c WHERE a.setid=c.setid AND a.item_type=c.item_type AND c.effdt <= %CurrentDateIn AND y.eff_status='A' AND a.SETID=y.SETID AND a.ITEM_TYPE=y.ITEM_TYPE AND a.EFFDT=y.EFFDT) AND y.item_type_cd = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DROP_WAIT_ACCT |
Character(3) | VARCHAR2(3) NOT NULL | Drop Wait List Account Type |
| 3 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |