PROCESS_INSTANCEMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
751=7.51 Release
752=7.52 Release
753=7.53 Release
801=8 SP1 Release
803=8 SP3 Release
840=8.40 Release
841=8.40 SP1
880=8.80 Release
UPG_PV_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PV_EASYFORM_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Easyform Type |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | INSTALLED_SW | Character(1) | VARCHAR2(1) NOT NULL | Installed? |
| 5 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 7 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 9 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 10 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 13 | IMAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL | The name of images used in Personalizations explanations. |
| 14 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 15 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 16 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 17 | PANELNAME | Character(18) | VARCHAR2(18) NOT NULL | Panelname |
| 18 | PV_MENUNAME_INQ | Character(30) | VARCHAR2(30) NOT NULL | Menu Name |
| 19 | PV_ITEMNAME_INQ | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 20 | PV_PANELNAME_INQ | Character(18) | VARCHAR2(18) NOT NULL | Inquiry Page Name |
| 21 | PV_KEYWORDS | Character(254) | VARCHAR2(254) NOT NULL | Search Keywords |
| 22 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 23 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 24 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 25 | PV_APPR_FLD | Character(18) | VARCHAR2(18) NOT NULL | Approval Field |
| 26 | PV_RULEID | Character(12) | VARCHAR2(12) NOT NULL | Rule Id |
| 27 | RTE_FROM_VALUE | Character(30) | VARCHAR2(30) NOT NULL | From Value |
| 28 | RTE_TO_VALUE | Character(30) | VARCHAR2(30) NOT NULL | To Value |
| 29 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 30 | RTE_CNTL_PROFILE | Character(30) | VARCHAR2(30) NOT NULL | Route Control Profile |
| 31 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 32 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 33 | COUNTER2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 2 |
| 34 | COUNTER3 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 3 |
| 35 | COUNTER4 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 4 |
| 36 | UPG_RELEASE | Character(4) | VARCHAR2(4) NOT NULL |
Upgrade Application Release
751=7.51 Release 752=7.52 Release 753=7.53 Release 801=8 SP1 Release 803=8 SP3 Release 840=8.40 Release 841=8.40 SP1 880=8.80 Release |
| 37 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 38 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 39 | EMAIL_ADDRESS | Long Character | CLOB | Email Addresses |