BANK_CDBANK_ACCT_KEYSCHEDULE_IDGFAP_SPS_SCH_VW(SQL View) |
Index Back |
|---|---|
Federal ECS Sch Vw |
| SELECT DISTINCT bank_setid , bank_cd , bank_acct_key , schedule_id FROM PS_PAYMENT_TBL WHERE schedule_id <> ' ' AND NOT EXISTS ( SELECT 'x' FROM ps_gfap_sps_sum WHERE bank_setid = PS_PAYMENT_TBL.bank_setid AND bank_cd = PS_PAYMENT_TBL.bank_cd AND bank_acct_key = PS_PAYMENT_TBL.bank_acct_key AND schedule_id = PS_PAYMENT_TBL.schedule_id) AND NOT EXISTS ( SELECT 'x' FROM ps_gfap_ecs_sum WHERE bank_setid = PS_PAYMENT_TBL.bank_setid AND bank_cd = PS_PAYMENT_TBL.bank_cd AND bank_acct_key = PS_PAYMENT_TBL.bank_acct_key AND schedule_id = PS_PAYMENT_TBL.schedule_id) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 2 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 3 | BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 4 | SCHEDULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |