RUN_CNTL_PC_AE1(SQL Table) |
Index Back |
---|---|
PC Process Run ControlPC Process Run Control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL |
Request Number
Default Value: 1 |
5 | BUPRJACT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
BU/Proj/Act Option
A=Business Unit/Project/Activity B=Business Unit E=All P=Business Unit/Project Default Value: E |
6 | BUTREEPRJACT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
BU/Tree/Prj/Act Optn
A=Business Unit/Project/Activity B=Business Unit E=All P=Business Unit/Project T=Tree Node |
7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
8 | DATE_RANGE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date E=All T=Transaction Date Default Value: E |
9 | INCENTIVE_ID_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Incentive ID Option
A=All Incentives V=Specific Incentives Default Value: A |
10 | CONTRACT_ID_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Project Contract
A=All V=Value Default Value: A |
11 | BILL_TO_CUST_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Bill to Customer
A=All V=Value Default Value: A |
12 | PROJECT_TYPE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Project Type Option
A=All V=Value Default Value: A |
13 | PROJECT_MGR_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Project Manager Option
A=All V=Value Default Value: A |
14 | BILL_CYCLE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Bill Cycle Option
A=All V=Value Default Value: A |
15 | PC_AM_RUN_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Asset Processing Destination
B=Summarize and Run Interface D=Asset Integration Rule Default I=Run Interface L=Sum, Run and Load Transactions R=Run Interface and Load S=Summarize Default Value: S |
16 | ASSET_ID_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Asset ID Option
A=Selected AM Unit / Asset ID B=Selected AM Unit E=All Default Value: E |
17 | TO_DT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
To Date Option
C=Current Date F=End Date - From Period P=Process Date S=Specify Date T=End Date - To Period Default Value: C |
18 | FROM_DT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
From Date Option
C=Current Date F=Begin Date - From Period N=No From Date P=Process Date S=Specify Date T=Begin Date - To Period Default Value: C |
19 | DST_TYPE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
DST Acct Type Option
A=All Lines D=DST Lines F=FRG Lines S=STX Lines V=Specific Lines Default Value: A |
20 | CUR_EFFDT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Currency Effective Date Option
A=Accounting Date T=Transaction Date V=Value |
21 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
22 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
23 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
24 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_VW |
25 | ACCOUNTING_DT | Date(10) | DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %DATE |
26 | TRANS_DT | Date(10) | DATE |
Transaction Date
Default Value: %DATE |
27 | CONTRACT_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Contract ID |
28 | INVOICE_DT | Date(10) | DATE |
Invoice Date
Default Value: %DATE |
29 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Default Value: RUN_CNTL_PC.RUN_CNTL_ID |
30 | RPT_DEST | Character(50) | VARCHAR2(50) NOT NULL | File Destination |
31 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: BI_BILL_TO_VW |
32 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
33 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
34 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
35 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
36 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
37 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
38 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
39 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
40 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
41 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
42 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
43 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
44 | PROJECT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Project Type
A=Activity G=Grant H=Phase P=Project S=Segment Prompt Table: PROJ_TYPE_TBL |
45 | ACTIVITY_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason |
46 | ANALYSIS_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Analysis Group
Prompt Table:
PROJ_AN_GRP_TBL
|
47 | PC_ANALYSIS_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
8/7/00 - Modified Long and Short Name on Translate Value "N" from None to All. When "N"o group is selected, this means the user wants ALL groups. This is more meaningful to the user.
G=Analysis Group N=All T=Analysis Type Default Value: N |
48 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
PROJ_ANTYPE_TBL
|
49 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
50 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
51 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
52 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table: CAL_DEFN_TBL |
53 | FROM_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | From Fiscal Year |
54 | FROM_PERIOD | Number(3,0) | SMALLINT NOT NULL | From Period |
55 | THRU_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Thru Fiscal Year |
56 | THRU_PERIOD | Number(3,0) | SMALLINT NOT NULL | Thru Period |
57 | DATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
From and To Date Type
A=Accounting Date J=Journal Date P=Posted Date T=Transaction Date Default Value: A |
58 | FROM_DATE | Date(10) | DATE |
From Date
Default Value: %DATE |
59 | THRU_DATE | Date(10) | DATE |
Through Date
Default Value: %DATE |
60 | ASOF_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | As Of Fiscal Year |
61 | ASOF_PERIOD | Number(3,0) | SMALLINT NOT NULL | As Of Period |
62 | AS_OF_DATE | Date(10) | DATE |
As of Date
Default Value: %date |
63 | DET_SUM_SW | Character(1) | VARCHAR2(1) NOT NULL |
Detail or Summary
D=Detail S=Summary Default Value: S |
64 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
65 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
66 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: PC_ASSET_RUN_VW |
67 | INCENTIVE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Investment Incentive ID
Prompt Table: PC_GNT |
68 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
69 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
70 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: SP_LEDG_A_NONVW |
71 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
72 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
73 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_BUGL_VW |
74 | RUN_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Interface Processing Options
DA=Depreciate All DC=Delete Conversion Data DD=Delete Data DF=Delete Fin DT=Delete Transactions FFC=Flexible Formula Calculator GS=Generate Scan Scope GT=Generate Trans LC=Load Conversion Data LD=Load Data LF=Load Fin Table from Conversion LT=Load Transactions MC=Mass Change N=None PM=Purge Mass Changes PP=Purge Mass Change Preview RM=Run Match UA=UnDepreciate All XD=Extract Data |
75 | RUN_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Program Run Code
1=Load ASSETGEN.ASC File 2=Load BOOKDATA.ASC File 3=Load LABLINFO.ASC File 4=Load PROPTMGR.ASC File N=None PRE=Preview Process PRO=Procedural RUN=Run Process SET=Set Process |
76 | FLEX_GROUP_ID | Number(8,0) | INTEGER NOT NULL | Line Number |
77 | TO_FLEX_GROUP_ID | Number(8,0) | INTEGER NOT NULL | To Line Number |
78 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
79 | TO_INTFC_ID | Number(8,0) | INTEGER NOT NULL |
To Interface ID
Default Value: 99999999 |
80 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL |
File Name
Default Value: C:\TEMP\FILE.TXT |
81 | TRANS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Types of Asset Management Transactions
ACR=Accretion Expense ADD=Asset Addition ADJ=Asset Cost Adjustment BKS=Book Adjustment BUD=Budgeted Depreciation DPR=Depreciation INF=Inflation Adjustment LEX=Lease Expense LPB=Budgeted Lease Payments LPY=Lease Payment PDP=Prior Period Depreciation PLP=Prior Lease Payment RAD=Manual Reserve Adjustment RCT=Asset Recategorization REI=Asset Reinstatement RES=Resume Depreciation RET=Asset Retirement RRC=Retro rate change for grp ast SUS=Suspend Depreciation TRF=Asset Transfer |
82 | TREE_BU | Character(5) | VARCHAR2(5) NOT NULL |
Tree Business Unit
Prompt Table: SP_BU_PC_NONVW |
83 | 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.
Default Value: %DATETIME |
84 | DTTM_STAMP_MSEC | Character(25) | VARCHAR2(25) NOT NULL | DateTime |
85 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN_VW |
86 | BUDG_ANALYSIS_GRP | Character(5) | VARCHAR2(5) NOT NULL |
Budget Analysis Group
Prompt Table: PROJ_AN_GRP_TBL |
87 | COST_ANALYSIS_GRP | Character(5) | VARCHAR2(5) NOT NULL |
Cost Analysis Group
Prompt Table: PROJ_AN_GRP_TBL |
88 | REV_ANALYSIS_GRP | Character(5) | VARCHAR2(5) NOT NULL |
Revenue Analysis Group
Prompt Table: PROJ_AN_GRP_TBL |
89 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PC_EMP_VW |
90 | EMPL_RCD_NUM | Number(3,0) | SMALLINT NOT NULL |
Project Employee Job Record #
Prompt Table: PC_EMPL_RCD_VW |
91 | PAY_END_DT | Date(10) | DATE |
Pay Period End Date
Default Value: %date Prompt Table: PC_EMPL_TIME |
92 | PROJ_RES_FIELD | Character(80) | VARCHAR2(80) NOT NULL |
Proj_Resource Field
Prompt Table: PRJ_EDIT_FLD_VW |
93 | PROJ_RES_FIELD2 | Character(18) | VARCHAR2(18) NOT NULL |
2nd PROJ_RESOURCE field
Prompt Table: PRJ_EDIT_FLD_VW |
94 | EDIT_TABLE | Character(18) | VARCHAR2(18) NOT NULL | Edit Table |
95 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %DATE Prompt Table: PROJ_TREE_DT_VW |
96 | TREE_EFFDT | Date(10) | DATE |
Effective date of the Tree
Prompt Table: PROJ_TREE_DT_VW |
97 | DST_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
98 | AE_CHUNK_1 | Character(1) | VARCHAR2(1) NOT NULL | One |
99 | AE_CHUNK_2 | Character(1) | VARCHAR2(1) NOT NULL | Two |
100 | AE_CHUNK_3 | Character(1) | VARCHAR2(1) NOT NULL | Three |
101 | AE_CHUNK_4 | Character(1) | VARCHAR2(1) NOT NULL | Four |
102 | AE_CHUNK_5 | Character(1) | VARCHAR2(1) NOT NULL | Five |
103 | SUMMARIZE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Summarize Type
A=By Asset P=By Profile Default Value: A |
104 | PO_SEL_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Purchasing Select Options
A=Requisitions / Purchase Orders P=Purchase Orders R=Requisitions Default Value: A |
105 | PC_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged Default Value: N |
106 | PROJ_ACT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Third party project/activity load option.
A=Activities B=Both Projects and Activities P=Projects Q=Projects and Resources R=Resources S=Activities and Resources T=Projects and Trees U=Projs, Activities & Resources Default Value: B |
107 | PC_INTFC_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Interface Options
A=All Interface ID's R=Range of Intfc ID's Default Value: A |
108 | PC_INTFC_RUN_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Interface Run Option
B=Edit and Load E=Edit Only L=Load Only U=Update Only Default Value: B |
109 | PC_THRESHOLD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Interface Line Options
A=All Lines R=Range of Lines Y/N Table Edit Default Value: N |
110 | PC_CCA_SW | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Order Adjustments
Y/N Table Edit Default Value: N |
111 | PC_PO_REV_SW | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Order Reversals
Y/N Table Edit Default Value: N |
112 | PC_REQ_REV_SW | Character(1) | VARCHAR2(1) NOT NULL |
Requisition Reversals
Y/N Table Edit Default Value: N |
113 | PURGE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Purge History without Archive
Y/N Table Edit Default Value: N |
114 | CUR_EFFDT | Date(10) | DATE |
Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
Default Value: %DATE |
115 | BILL_CYCLE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table: BI_CYCLE_VW |
116 | PROJECT_MANAGER | Character(11) | VARCHAR2(11) NOT NULL |
Project Manager
Prompt Table: PROJ_MGR_VW |
117 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
Prompt Table: OPRID_VW |
118 | SCENARIO | Character(10) | VARCHAR2(10) NOT NULL |
A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
Prompt Table: BD_SCENARIO_TBL |
119 | ACT_EST_SCHED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Processing Option
A=Process Actuals F=Load time from flat file R=Request Estimates Default Value: R |
120 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
121 | TO_CUR | Character(3) | VARCHAR2(3) NOT NULL |
To Currency Code
Prompt Table: CURRENCY_CD_TBL |
122 | BUSINESS_UNIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units V=Specific Business Unit Default Value: A |
123 | JOURNAL_ID_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal ID Option
A=All Journal IDs S=Some Journal ID Values Default Value: A |
124 | JOURNAL_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL |
Range From Journal ID
Prompt Table: PC_GL_RUN_VW |
125 | JOURNAL_ID_TO | Character(10) | VARCHAR2(10) NOT NULL |
Range to Journal ID
Prompt Table: PC_GL_RUN_VW |
126 | RPOGRP | Character(30) | VARCHAR2(30) NOT NULL |
Summarization Option
Prompt Table: PC_RPO_GRPS |
127 | PROJECT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted C=Closed H=Hold O=Open P=Proposed |
128 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
129 | TREE_LEVEL | Character(10) | VARCHAR2(10) NOT NULL | Tree Level Number |
130 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
PROJ_TREE_VW
|
131 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table:
PC_TREE_NODE_VW
|
132 | TREE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Tree SetID |
133 | RUN_PROCESS_BTN | Character(1) | VARCHAR2(1) NOT NULL | Run Process |