PIR_RPT_STG_TAS(SQL Table) |
Index Back |
|---|---|
PIR_RPT_STG_TASChild record of PIR_PMT_RPT_STG |
| # | 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 | PYMNT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 5 | PYMNT_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Payment Status
A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted |
| 6 | FUND_CODE |
Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_ALL_VW |
| 7 | SPS_TAS |
Character(27) | VARCHAR2(27) NOT NULL | Sender Treasury Account Symbol |
| 8 | SPS_BETC |
Character(8) | VARCHAR2(8) NOT NULL | Sender Business Event Type |
| 9 | SETID_FUND | Character(5) | VARCHAR2(5) NOT NULL | Setid for Fund |
| 10 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 11 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 12 | SUB_LEVEL_CD | Character(2) | VARCHAR2(2) NOT NULL | Sub level prefix code |
| 13 | ALLO_TR_AGENCY | Character(3) | VARCHAR2(3) NOT NULL | Allocation Transfer Agency Identifier |
| 14 | AGENCY_ID1 | Character(3) | VARCHAR2(3) NOT NULL |
TAS agency id
Prompt Table: TAS_AGENCY |
| 15 | BEGIN_PERIOD_AVAIL | Character(4) | VARCHAR2(4) NOT NULL | Beginning Period of Availability (BPOA) |
| 16 | END_PERIOD_AVAIL | Character(4) | VARCHAR2(4) NOT NULL | Ending Period of Availability (EPOA) |
| 17 | AVAIL_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Availability Type Code
A=Treasury cental smmry account C=Cancelled F=Clearing/suspense account M=Merged surplus account X=No-year account |
| 18 | MAIN_ACCOUNT | Character(4) | VARCHAR2(4) NOT NULL | Main Account TAS |
| 19 | SUB_ACCOUNT | Character(3) | VARCHAR2(3) NOT NULL | Sub Account TAS |