SSF_PND_PMTB_VW(SQL View) |
Index Back |
|---|
| SELECT b.institution_set , a.business_unit , b.common_id , b.sa_id_type , a.adm_appl_nbr , a.appl_dep_nbr , SUM(a.payout_amt ) FROM PS_SF_PAYMENT_DTL a , ps_sf_payment b WHERE a.sf_pmt_ref_nbr = b.sf_pmt_ref_nbr AND a.seqnum = b.seqnum AND SA_ID_TYPE ='P' AND B.CR_CARD_TRANS_SRC = 'P' AND ((b.SF_PAYMENT_STATUS = 'S' OR b.SF_PAYMENT_STATUS = 'A' OR b.SF_PAYMENT_STATUS = 'B') AND b.SF_POST_STATUS <> 'S') GROUP BY b.institution_set, a.business_unit, b.common_id, b.sa_id_type, a.adm_appl_nbr, a.appl_dep_nbr |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION_SET | Character(5) | VARCHAR2(5) NOT NULL | Institution Set |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 4 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 5 | ADM_APPL_NBR | Character(8) | VARCHAR2(8) NOT NULL | Application Nbr |
| 6 | APPL_DEP_NBR | Number(3,0) | SMALLINT NOT NULL | Application Deposit Nbr |
| 7 | PAYOUT_AMT | Number(17,2) | DECIMAL(16,2) NOT NULL | Pay Out Amt |