PROCESS_INSTANCEDefault Value: AV_WEB_INSTALL.SEQNO
Default Value: AV_WEB_ACCT.AV_DES_BU
Default Value: AV_WEB_ACCT.DESIGNATION
AV_INV_GDES_AET(SQL Table) |
Index Back |
|---|---|
Involvement Session StateState record for Involvement designation records. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AV_RECEIPT_NBR | Character(12) | VARCHAR2(12) NOT NULL | Receipt Number |
| 3 | SEQNO | Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: AV_WEB_INSTALL.SEQNO |
| 4 | AV_DES_BU | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AV_WEB_ACCT.AV_DES_BU |
| 5 | DESIGNATION | Character(11) | VARCHAR2(11) NOT NULL |
Designation
Default Value: AV_WEB_ACCT.DESIGNATION |
| 6 | DES_PCT_AMT_ENTRY | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount |
| 7 | DESIGNATION_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Designation Pct |
| 8 | DES_PCT_TOT | Number(8,4) | DECIMAL(7,4) NOT NULL | Percent |
| 9 | AV_COUNT | Number(3,0) | SMALLINT NOT NULL | Count |
| 10 | CNT_CNTRLVAL | Number(3,0) | SMALLINT NOT NULL | Count Set Control Value |
| 11 | AV_INST_TYPE | Character(6) | VARCHAR2(6) NOT NULL | Designation Type |
| 12 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |