RUN_CNTL_PC_AE1

(SQL Table)
Index Back

PC Process Run Control

PC 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
Set Control Field: TREE_BU

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
Set Control Field: TREE_BU

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

Prompt Table: PROJ_ROLE
Set Control Field: TREE_BU

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
Set Control Field: TREE_BU

131 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

Prompt Table: PC_TREE_NODE_VW
Set Control Field: TREE_BU

132 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID
133 RUN_PROCESS_BTN Character(1) VARCHAR2(1) NOT NULL Run Process