TR_RULE_AET(SQL Table) |
Index Back |
|---|---|
TR_RULE_UPD default state recThe following state record is used in the Sub Rule Update process (TR_RULE_UPD). This is the default state record for the process. |
| # | 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 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | SUB_RULE_ID | Character(20) | VARCHAR2(20) NOT NULL | The unique key identifier for a given accounting template substitution rule. |
| 7 | NEW_SUB_RULE_ID | Character(20) | VARCHAR2(20) NOT NULL | The unique key identifier for a given accounting template substitution rule. Used by the Copy / Rename /Delete Substitution Rule process. |
| 8 | ACTION_CD | Character(1) | VARCHAR2(1) NOT NULL |
Action Code
C=Copy D=Delete R=Rename |
| 9 | ACCTG_TMPL_ID | Character(15) | VARCHAR2(15) NOT NULL | A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits. |
| 10 | ACCTG_TMPL_LINE | Number(3,0) | SMALLINT NOT NULL | A sequential number that indicates the number of accounting debit or credit lines defined within a giv |
| 11 | SOURCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Categorizes Treasury Accounting Templates according to the type of transaction they process (badly named field). Keep this field in sync with TR_SOURCE_CD and TRA_SOURCE_CD.
01/11/99 - CMH - Removed 'A' from XLAT, will use 'W' for TR Wires
11/20/99 - MC - Added 'H' for Hedge Accounting
06/29/00 - RV - Changed 'F' to Fees. Fees now cover Deal Fees, LC
Fees, Facility Fees, etc.
09/08/00 - RV - Changed Treasury Wires to EFT Requests.
07/15/04 - SD - Added 'P' for Investment Pools
B=BSP D=Deals F=Fees H=Hedge Accounting I=Interest P=Investment Pools W=EFT Requests |
| 12 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 13 | NEW_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Flag that indicates whether billing status of New should be included on the federal highway extract file. |
| 14 | TEST_ATTRIBUTE | Character(18) | VARCHAR2(18) NOT NULL | Represents the treasury deal transaction attribute that is subject to a predefined accounting template |
| 15 | SET_CF | Character(18) | VARCHAR2(18) NOT NULL | Represents a treasury accounting template substitution rule that determines which General Ledger chartfield is |
| 16 | TRA_ATTR_VALUE | Character(30) | VARCHAR2(30) NOT NULL | The desired source transaction attribute value defined as a substitution rule within a given accounting entry. |
| 17 | TRA_CHRTFLD_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
The desired accounting chartfield value defined as a substitution rule within a given accounting entry.
Prompt Table: %EDIT_CF |
| 18 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 19 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 20 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler |
| 21 | SYSTEM_DATE | Date(10) | DATE | System Date |
| 22 | DTTM_STAMP | 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. |
| 23 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 24 | AE_APPSTATUS | Number(1,0) | SMALLINT NOT NULL | AE Application Warning Status |
| 25 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 26 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 27 | MESSAGE_PARM1 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 1 |
| 28 | MESSAGE_PARM2 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 2 |
| 29 | MESSAGE_PARM3 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 3 |
| 30 | MESSAGE_PARM4 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 4 |
| 31 | MESSAGE_PARM5 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 5 |
| 32 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 33 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 34 | FIRST_PASS_SW | Character(1) | VARCHAR2(1) NOT NULL | First Pass Switch |
| 35 | SQLROWS_TAO | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |