BUSINESS_UNITCOMMON_IDSTRMACCT_PP_AU_VW(SQL View) |
Index Back |
|---|---|
Term Summary SF |
| SELECT DISTINCT C.BUSINESS_UNIT , A.COMMON_ID , A.STRM , C.INSTITUTION , B.DESCR , ' ' , 0 FROM PS_SF_PAYMENT A , PS_TERM_VAL_TBL B , PS_BUS_UNIT_TBL_SF C , PS_ISET_BU_DTL D WHERE A.INSTITUTION_SET <> ' ' AND A.INSTITUTION_SET = D.INSTITUTION_SET AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.STRM = B.STRM AND C.SF_ENABLE_WEB_PAY = 'Y' AND A.SA_ID_TYPE = 'P' AND (A.SF_PAYMENT_STATUS = 'S' OR A.SF_PAYMENT_STATUS = 'A' OR A.SF_PAYMENT_STATUS = 'B') AND A.SF_POST_STATUS <> 'S' AND A.CR_CARD_TRANS_SRC = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | BALANCE_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Charge Balance |