STL_INST_TMP(SQL Table) |
Index Back |
|---|---|
Temp table used to de-normalizThis temporary table is used to facilitate the de-normalization of STL_INSTRUCTION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SETTLEMENT_ID | Character(5) | VARCHAR2(5) NOT NULL | A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc |
| 3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 6 | BANK_ID_QUAL | Character(3) | VARCHAR2(3) NOT NULL | "A bank/counterparty attribute that determines |
| 7 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 8 | BRANCH_ID | Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 9 | BANK_ACCT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit 03=Checking Account 05=Stock 06=Bond 07=Life Insurance Value 08=Retirement Account 10=Business Account 11=Trust Fund Account 12=Stock & Bond Account 13=Life Insurance Acct CA=Current Account CH=Charges Account DA=Demand Deposit LN=Loan RD=Return Items on DDA RS=Return Items-Savings SA=Settlement Account SV=Savings Account Z=Mutually Defined |
| 10 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 11 | CHECK_DIGIT | Character(2) | VARCHAR2(2) NOT NULL | Check Digit |
| 12 | DFI_ID_QUAL | Character(2) | VARCHAR2(2) NOT NULL |
A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number 02=Swift ID/BIC 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined |
| 13 | DFI_ID_NUM | Character(12) | VARCHAR2(12) NOT NULL | A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun |
| 14 | BANK_ACCT_QUAL | Character(1) | VARCHAR2(1) NOT NULL |
"An account attribute that determines
C=Corporate Account |
| 15 | EFT_PYMNT_FMT_CD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Format
00=Standard SWIFT transfer 10=Urgent SWIFT 15=Euro-Transfer 21=Check, w/ receipt confirmation 22=Check, Urgent 23=Check, urgent w/ receipt 40=Postal Order CTX=Corp Trade Exchange PBC=Check, standard PPD=Prearranged Pay & Deposit WRT=Wire Transfer |
| 16 | EFT_RTNG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Complex Routing
D=Use DFI ID N=None R=Use Complex Routing |
| 17 | EFT_RTNG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Routing Status
C=Complete I=Incomplete |
| 18 | EFT_TRANS_HANDLING | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Handling
D=Payment Only P=Prenotification X=Payment and Advice |
| 19 | EFT_DOM_COSTS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Domestic Costs
1=Payer's Domestic Account 2=Payer's Foreign Account 3=Payee's Account 4=Trans Exp to Pyr, other to Pye |
| 20 | EFT_CORR_COSTS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Correspondent's Costs
1=Payer's Domestic Account 2=Payer's Foreign Account 3=Payee's Account |
| 21 | EFT_CROSSED_CHECK | Character(1) | VARCHAR2(1) NOT NULL | Crossed Check |
| 22 | EFT_CHECK_FWRD_CD | Character(1) | VARCHAR2(1) NOT NULL |
Check Forwarding
1=Payer's Bank 2=Payer 3=Payee 4=Payee's Bank |
| 23 | EFT_CHECK_DRAW_CD | Character(1) | VARCHAR2(1) NOT NULL |
Bank Check Drawn On
1=Payer's Bank 2=Payee's Bank |
| 24 | EFT_PAY_INST_CD1 | Character(3) | VARCHAR2(3) NOT NULL |
Payment Instruction 1
ACC=/ACC/ BEN=/BENONLY/ CHK=/CHECK/ COR=/CORPTRAD/ HLD=/HOLD/ INT=/INT/ IRR=PAYMENT IRREVOCABLE PHB=/PHONEBEN/ PHI=/PHONIBK/ PHN=/PHON/ RC1=ADV BEN W/CHARGES RC2=ADV BEN W/O CHARGES RCB=/RCB/ REC=/REC/ REJ=/REJT/ RET=BEN UNKNOWN RETURN TEB=/TELEBEN/ TEI=/TELEIBK/ TEL=/TELE/ XFR=INTERCOMPANY TRANSFER |
| 25 | EFT_PAY_INST_CD2 | Character(3) | VARCHAR2(3) NOT NULL | Payment Instruction 2 |
| 26 | EFT_PAY_INST_CD3 | Character(3) | VARCHAR2(3) NOT NULL | Payment Instruction 3 |
| 27 | EFT_PAY_INST_CD4 | Character(3) | VARCHAR2(3) NOT NULL | Payment Instruction 4 |
| 28 | EFT_PAY_INST_REF1 | Character(40) | VARCHAR2(40) NOT NULL | Payment Instruction Ref 1 |
| 29 | EFT_PAY_INST_REF2 | Character(40) | VARCHAR2(40) NOT NULL | Payment Instruction Ref 2 |
| 30 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 31 | NAME1_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 1 Alternate Char Set |
| 32 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 33 | NAME2_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 2 Alternate Char Set |
| 34 | BENEFICIARY_BANK | Character(30) | VARCHAR2(30) NOT NULL | The bank/counterparty associated with a given beneficiary. |
| 35 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 36 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 37 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 38 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 39 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 40 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 41 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 42 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 43 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 44 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 45 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 46 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 47 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 48 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 49 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 50 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 51 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 52 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Int'l Prefix |
| 53 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 54 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone Extension |
| 55 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
| 56 | DESCRLONG | Long Character | CLOB | Long Description |