EX_TRANS_DEFN(SQL Table) |
Index Back |
---|---|
Transaction DefinitionTransaction definition record. This record (and its child) is used to map a transaction to its corresponding AWE process and stage. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
2 | APPR_TRANS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Approval Transaction Type.
CA=Cash Advance ER=Expense Report TA=Travel Authorization TJ=Time Adjustment TR=Time Report |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
7 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
8 | AMOUNT_BASED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Amount Based Flag. Determines if a transaction is monetary based or hours based.
H=Hours Based M=Monetary Amount Based Default Value: M |
9 | EXCEPTION_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Exception Oprid. The operator id that all transactions with routing exceptions are routed to.
Prompt Table: PSOPRDEFN_VW |