TR_BTF_TIMR_AET(SQL Table) |
Index Back |
|---|---|
Treasury BTF Timer AET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | IMPORT_OBJECT | Character(2) | VARCHAR2(2) NOT NULL |
Import Object
10=Bank Statement 20=Payment Acknowledgement 30=Payment Import 40=Investment Pools Import 50=Stock Quote Import 60=Security Market Value Import 70=Security Definition Import 80=Sanctions List Import 90=Cash Forecast Import |
| 5 | BNK_STMT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bank statement type
1=Current Day 2=Previous Day 3=Statement Analysis |
| 6 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL |
Process Name
Prompt Table: PRCSDEFN |
| 7 | RUNCNTLID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 8 | RQSTDTTM | DateTime(26) | TIMESTAMP | Request Date/Time |
| 9 | MAX_WAIT_TIME | Number(9,0) | DECIMAL(9) NOT NULL |
Maximum Wait Time (Minutes)
Default Value: 4 |
| 10 | DTTM_STAMP_SEC | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 11 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |