PC_VP_AET(SQL Table) |
Index Back |
|---|---|
Variance Pricing state record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 8 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 9 | BUSINESS_UNIT_VP | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | ACCOUNTING_DATE_OP | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Date
D=System Date O=Original Date S=Specify Date |
| 11 | ACCOUNTING_DT | Date(10) | DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %DATE |
| 12 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 13 | ANALYSIS_TYPE_MAP | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type Map |
| 14 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL | Contracts Business Unit |
| 15 | CA_RQST_SRC | Character(3) | VARCHAR2(3) NOT NULL |
Contract Classification
FED=Federal Reimbursable Agreement GEN=Generic Application GOV=Government INT=Internal OND=CRM Field Services On Demand STD=Standard |
| 16 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 17 | DATE_RANGE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date E=All T=Transaction Date |
| 18 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Default Value: RUN_CNTL_PC.RUN_CNTL_ID |
| 19 | DETAIL_NO | Number(3,0) | SMALLINT NOT NULL | Detail Number |
| 20 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 21 | FROM_DATE | Date(10) | DATE | From Date |
| 22 | LAST_RESOURCE_ID | Number(20,0) | DECIMAL(20) NOT NULL | Last Transaction ID |
| 23 | LINE_NO | Number(3,0) | SMALLINT NOT NULL | Line Number |
| 24 | PC_PRICING_PB | Character(1) | VARCHAR2(1) NOT NULL | Run Pricing |
| 25 | PC_RATE_CATEGORY | Character(15) | VARCHAR2(15) NOT NULL | Rate Set Category |
| 26 | PC_SWITCH_1 | Character(1) | VARCHAR2(1) NOT NULL | Reprice Rows? |
| 27 | PC_SWITCH_2 | Character(1) | VARCHAR2(1) NOT NULL | Price Unpriced Rows? |
| 28 | PC_SWITCH_3 | Character(1) | VARCHAR2(1) NOT NULL | Recalculate Tiered Pricing |
| 29 | PC_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL | Rate Template ID |
| 30 | PC_TEMPLATE_ID2 | Character(15) | VARCHAR2(15) NOT NULL | Rate Template ID |
| 31 | PC_VAR_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Variance Pricing Rate Option - Rate Plan / Rate Set / Rate Set Category
C=Rate Set Category P=Rate Plan S=Rate Set |
| 32 | PC_VAR_SYS_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Variance Pricing Option
C=Correction N=Normal |
| 33 | PC_VP_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
Requires Variance Pricing Approval
A=Approved N=No Y=Yes |
| 34 | PURGE_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Purge History without Archive |
| 35 | RATE_DEF_COST | Character(1) | VARCHAR2(1) NOT NULL | Rate Definition to track cost rates. |
| 36 | RATE_DEF_BIL | Character(1) | VARCHAR2(1) NOT NULL | Rate Definition to track billing rates. |
| 37 | RATE_DEF_REV | Character(1) | VARCHAR2(1) NOT NULL | Rate Definition to track revenue rates. |
| 38 | RATE_PLAN | Character(15) | VARCHAR2(15) NOT NULL | Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line. |
| 39 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |
| 40 | RESOURCE_ID_FROM | Character(40) | VARCHAR2(40) NOT NULL | Original Transaction ID |
| 41 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 42 | SIGNED_VALUE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Amount Multiplier |
| 43 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 44 | SUM_VP | Character(1) | VARCHAR2(1) NOT NULL | variance pricing summarization indicator |
| 45 | TEMPLATE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is either expense sheet or travel authorization. Cash advances do not use templates.
Projects is using types are R and C.
C=Contract E=Expense Report R=Standard T=Travel Authorization |
| 46 | THRU_DATE | Date(10) | DATE | Through Date |
| 47 | TOLERANCE_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Tolerance Amount |
| 48 | VAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Variance Status
A=Active I=Inactive P=Pending |
| 49 | VP_EFFECTIVE_DATE | Date(10) | DATE | Effective Date |
| 50 | YES | Character(1) | VARCHAR2(1) NOT NULL | |
| 51 | WHERE_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 52 | WORK_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Count of Anything |
| 53 | WORK_CNT2 | Number(10,0) | DECIMAL(10) NOT NULL | Work Count 2 |
| 54 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |