INSTALLATION_PC

(SQL Table)
 Index Back

System Options - PS/PC

System Options - PS/PC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEFAULT_BU Character(5) VARCHAR2(5) NOT NULL Default Business Unit

Prompt Table: SP_BU_PC_NONVW

2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: USD

Prompt Table: CURRENCY_CD_TBL

3 CAT_EDIT_OPTION Character(3) VARCHAR2(3) NOT NULL Category Edit Option
IND=Independent
OVR=Override
REL=Related

Default Value: IND

4 SUB_EDIT_OPTION Character(3) VARCHAR2(3) NOT NULL SubCategory Edit Option
IND=Independent
OVR=Override
REL=Related

Default Value: IND

5 CATEGORY_EDIT Character(15) VARCHAR2(15) NOT NULL Category Edit Table

Default Value: PROJ_CATG_TBL

Prompt Table: RECDEFN_VW

6 SUBCATEGORY_EDIT Character(15) VARCHAR2(15) NOT NULL SubCategory Edit Table

Default Value: PROJ_SUBCAT_TBL

Prompt Table: RECDEFN_VW

7 AN_TYPE_AP Character(3) VARCHAR2(3) NOT NULL Payables

Default Value: ACT

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

8 AN_TYPE_EX Character(3) VARCHAR2(3) NOT NULL Expenses

Default Value: ACT

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

9 AN_TYPE_IN Character(3) VARCHAR2(3) NOT NULL Inventory

Default Value: ACT

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

10 AN_TYPE_AR_ADJ Character(3) VARCHAR2(3) NOT NULL Receivables Adjustment

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

11 AN_TYPE_OM Character(3) VARCHAR2(3) NOT NULL Order Management

Default Value: ORD

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

12 AN_TYPE_PO_CCA Character(3) VARCHAR2(3) NOT NULL Purchasing Closure

Default Value: CCA

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

13 AN_TYPE_PO_CRV Character(3) VARCHAR2(3) NOT NULL Purchasing Reversals

Default Value: CRV

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

14 AN_TYPE_PO_RRV Character(3) VARCHAR2(3) NOT NULL Requisition Reversals

Default Value: RRV

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

15 AN_TYPE_PO_PO Character(3) VARCHAR2(3) NOT NULL Purchase Orders

Default Value: COM

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

16 AN_TYPE_PO_REQ Character(3) VARCHAR2(3) NOT NULL Requisitions

Default Value: REQ

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

17 AN_TYPE_TL Character(3) VARCHAR2(3) NOT NULL Time / Labor Actuals

Default Value: PAY

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

18 AN_TYPE_TL_NPY Character(3) VARCHAR2(3) NOT NULL No Pay analysis type.

Default Value: NPY

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

19 AN_TYPE_TL_EST Character(3) VARCHAR2(3) NOT NULL Time / Labor Estimates

Default Value: TLA

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

20 AN_TYPE_TL_BI Character(3) VARCHAR2(3) NOT NULL Time / Labor Billing Estimate

Default Value: TLB

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

21 AN_TYPE_TL_CON Character(3) VARCHAR2(3) NOT NULL Contractor Time / Labor

Default Value: TLC

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

22 AN_TYPE_TT_EX Character(3) VARCHAR2(3) NOT NULL Mobile Time / Expense

Default Value: TLX

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

23 AN_TYPE_CA Character(3) VARCHAR2(3) NOT NULL Contracts Fixed Fee Billed

Default Value: FBD

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

24 AN_TYPE_CA_REV Character(3) VARCHAR2(3) NOT NULL Contracts Fixed Fee Revenue

Default Value: FRV

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

25 AN_TYPE_WM_TU Character(3) VARCHAR2(3) NOT NULL Maintenance Mgmt Tools Usage

Default Value: TUG

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

26 AN_TYPE_ESA_BIL Character(3) VARCHAR2(3) NOT NULL Analysis type for ESA Bill estimate

Default Value: ESB

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

27 AN_TYPE_ESA_COST Character(3) VARCHAR2(3) NOT NULL Analysis type for ESA Cost estimate

Default Value: ESC

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

28 AN_TYPE_AM_ASP Character(3) VARCHAR2(3) NOT NULL Asset Percentage Distribution
29 AN_TYPE_AM_CLS Character(3) VARCHAR2(3) NOT NULL Summarize by Asset
30 AN_TYPE_AM_COR Character(3) VARCHAR2(3) NOT NULL Cost of Removal
31 AN_TYPE_AM_CRR Character(3) VARCHAR2(3) NOT NULL Cost of Removal Offset
32 AN_TYPE_AM_PCA Character(3) VARCHAR2(3) NOT NULL Profile Reversal
33 AN_TYPE_AM_PCL Character(3) VARCHAR2(3) NOT NULL Summarize by Profile
34 AN_TYPE_AM_PFS Character(3) VARCHAR2(3) NOT NULL Proceeds from Sale
35 AN_TYPE_AM_PSR Character(3) VARCHAR2(3) NOT NULL Proceeds from Sale Offset
36 AN_TYPE_AM_RCL Character(3) VARCHAR2(3) NOT NULL Retire assets not in Projects
37 AN_TYPE_AM_RET Character(3) VARCHAR2(3) NOT NULL Summarize for Retirement
38 RRV_OPTN Character(1) VARCHAR2(1) NOT NULL Requisition Reversal
A=COM Amount
Q=REQ Rate
X=REQ Total

Default Value: Q

39 CRV_OPTN Character(1) VARCHAR2(1) NOT NULL Purchase Order Reversal
A=ACT Amount
Q=COM Rate

Default Value: Q

40 PC_REQ_REV_SW Character(1) VARCHAR2(1) NOT NULL Requisition Reversals
41 PC_PO_REV_SW Character(1) VARCHAR2(1) NOT NULL Purchase Order Reversals
42 AN_TYPE_GL Character(3) VARCHAR2(3) NOT NULL General Ledger

Default Value: ACT

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

43 ANALYSIS_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

44 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

45 PC_SCH_ANGRP_BUD Character(5) VARCHAR2(5) NOT NULL Analysis Group Budgets

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

46 PC_SCH_ANGRP_ACT Character(5) VARCHAR2(5) NOT NULL Analysis Group for Actuals

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

47 PC_SCH_ANGRP_3PWRK Character(3) VARCHAR2(3) NOT NULL Analysis Group for 3rd-Party Work entry.

Default Value: TLX

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

48 STATUS_CNTRL_SW Character(1) VARCHAR2(1) NOT NULL Enable Status Control
N=No
Y=Yes

Y/N Table Edit

Default Value: N

49 IN_USE_SW Character(1) VARCHAR2(1) NOT NULL Table in use switch

Default Value: N

50 LAST_PROJECT_ID Number(15,0) DECIMAL(15) NOT NULL Last Project ID
51 LAST_RESOURCE_ID Number(20,0) DECIMAL(20) NOT NULL Last Transaction ID

Default Value: 10000000

52 AN_GRP_ACTV_BUD Character(5) VARCHAR2(5) NOT NULL Budget Analysis Group

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

53 PC_REV_BUD_AN_GRP Character(5) VARCHAR2(5) NOT NULL Revenue budget analysis group

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

54 AN_GRP_TOT_COSTS Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

55 AN_GRP_TOT_REV Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

56 SEPARATE_DRCR Character(1) VARCHAR2(1) NOT NULL Enable Separate Debit/Credit

Y/N Table Edit

Default Value: N

57 LAUNCH_TL_TO_PC Character(1) VARCHAR2(1) NOT NULL Load Time Automatically

Y/N Table Edit

Default Value: N

58 RATE_DATE_OPTN Character(1) VARCHAR2(1) NOT NULL Date Option
A=Acct Dt
T=Trans Dt

Default Value: A

59 PC_OLT_SW Character(1) VARCHAR2(1) NOT NULL Reprice OLT's?

Default Value: Y

60 PC_DEFER_SW Character(1) VARCHAR2(1) NOT NULL Reprice Deferrals

Default Value: N

61 AN_GRP_SECURITY Character(5) VARCHAR2(5) NOT NULL Security Analysis Group for Projects.

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

62 TOLERANCE Signed Number(13,8) DECIMAL(11,8) NOT NULL Tolerance Percent
63 COST_TYPE_SW Character(1) VARCHAR2(1) NOT NULL Cost Type From Transaction

Y/N Table Edit

Default Value: N

64 DEPTID_SW Character(1) VARCHAR2(1) NOT NULL Department ID From Transaction

Default Value: Y

65 ALLOWOPS Character(1) VARCHAR2(1) NOT NULL Allow Multiple RPO Operators
66 PC_INVEST_INCNTVE Character(1) VARCHAR2(1) NOT NULL Enable Investment Incentives
N=No
Y=Yes
67 LAST_TEMPLATE Number(15,0) DECIMAL(15) NOT NULL Last Template ID
68 PC_CAL_TYPE_MT Character(2) VARCHAR2(2) NOT NULL Monthly Calendar

Prompt Table: CAL_DETL_VW
Set Control Field: ANALYSIS_SETID

69 PC_CAL_TYPE_QT Character(2) VARCHAR2(2) NOT NULL Quarterly Calendar

Prompt Table: PC_CAL_SUMM_VW
Set Control Field: ANALYSIS_SETID

70 PC_CAL_TYPE_YR Character(2) VARCHAR2(2) NOT NULL Yearly Calendar

Prompt Table: PC_CAL_SUMM_VW
Set Control Field: ANALYSIS_SETID

71 PC_UPD_MYPROJ_TM Character(1) VARCHAR2(1) NOT NULL Update My Projects list of Team Members once they are inserted into a project.
N=No
Y=Yes
72 PC_TREE_FILEPATH Character(30) VARCHAR2(30) NOT NULL A temporary file path for processes which write to files. Used in the Tree Loader (PC_TREE_LOAD) program to write the tree import data to a specified filepath. Also used in Program Budgeting as a temporary place for the Load from Excel process.

Default Value: c:\temp\

73 PC_SCH_RST_GRP Character(4) VARCHAR2(4) NOT NULL Resource Pool Grouping - either Define Resources at the Resource Type level or define Resources at the Empl-ID level.
EMPL=Resource EmplID
RSTP=Source Type
74 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Default Value: MHR

Prompt Table: UNITS_TBL

75 PC_QPLACE Character(1) VARCHAR2(1) NOT NULL PC_LOTUS_QUICKPLACE
76 PC_EROOM Character(1) VARCHAR2(1) NOT NULL eRoom
77 AN_TYPE_GM_BUD Character(3) VARCHAR2(3) NOT NULL Project resource analysis type for Grants

Default Value: BUD

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

78 GM_CSR_AP Character(3) VARCHAR2(3) NOT NULL Cost Sharing Payables

Default Value: CAC

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

79 GM_CSR_EX Character(3) VARCHAR2(3) NOT NULL Cost Sharing Expenses

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

80 GM_CSR_GL Character(3) VARCHAR2(3) NOT NULL Cost Sharing General Ledger

Default Value: CGE

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

81 GM_CSR_GM_BUD Character(5) VARCHAR2(5) NOT NULL Cost Sharing - Budgets

Default Value: CBU

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

82 GM_CSR_IN Character(3) VARCHAR2(3) NOT NULL Cost Sharing Inventory

Default Value: CAC

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

83 GM_CSR_OM Character(3) VARCHAR2(3) NOT NULL Cost Sharing Order Management

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

84 GM_CSR_PO_CCA Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - Close Adj

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

85 GM_CSR_PO_CRV Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - COM Reversal

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

86 GM_CSR_PO_PO Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - Purchase Ord

Default Value: CCO

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

87 GM_CSR_PO_REQ Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - Requisition

Default Value: CRQ

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

88 GM_CSR_PO_RRV Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - REQ Reversal

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

89 GM_CSR_TL Character(3) VARCHAR2(3) NOT NULL Cost Sharing TL - Actuals

Default Value: CPY

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

90 GM_CSR_TL_BI Character(3) VARCHAR2(3) NOT NULL Cost Sharing TL - Billing Est

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

91 GM_CSR_TL_EST Character(3) VARCHAR2(3) NOT NULL Cost Sharing TL - Estimates

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

92 GM_CSR_TL_CON Character(3) VARCHAR2(3) NOT NULL Grants cost sharing analysis type for Time and Labor Contractors.

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

93 GM_CSR_TT_EX Character(3) VARCHAR2(3) NOT NULL Cost Sharing Mobile Time

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

94 PC_FND_DIST_SW Character(1) VARCHAR2(1) NOT NULL This field is used to indicate the use of Funds Distribution functionality.

Y/N Table Edit

Default Value: N

95 PC_ENABLE_OPN_PRD Character(1) VARCHAR2(1) NOT NULL Enable Open Period Control

Y/N Table Edit

Default Value: N

96 PC_USE_OPEN_PERIOD Character(2) VARCHAR2(2) NOT NULL Open Period Source
GL=General Ledger
PC=Projects

Default Value: PC

97 ORG_SW Character(1) VARCHAR2(1) NOT NULL Use Organization

Y/N Table Edit

Default Value: N

98 FILE_ATTACH_OPT Character(1) VARCHAR2(1) NOT NULL An indicator to determine whether to attach files to FTP server or to the database.
D=Database
S=File Server

Default Value: S

99 PM_REVIEW_FLAG Character(1) VARCHAR2(1) NOT NULL Review Required for Billing
N=PM Review not used
Y=PM Review enabled

Default Value: N

100 PM_POP_FLAG Character(1) VARCHAR2(1) NOT NULL Separate POP Exceptions
N=No
Y=Yes

Default Value: N

101 PC_USE_BUD_FLG Character(1) VARCHAR2(1) NOT NULL Enable Projects Budgeting
N=No
Y=Yes

Default Value: N

102 PC_SUM_CAL_ID Character(2) VARCHAR2(2) NOT NULL Default Summary Calendar ID

Default Value: MN

Prompt Table: CAL_BP_VW
Set Control Field: ANALYSIS_SETID

103 NUM_PERIODS Number(2,0) SMALLINT NOT NULL Number of Time Periods

Default Value: 12

104 PC_TIME_DT_OPT Character(1) VARCHAR2(1) NOT NULL Expenses Time Report Date Option: selects which date, Period End Date or Date Under Report, to use as the accounting date for PC_EX_TO_PC
D=Date Under Report
P=Period End Date

Default Value: D

105 AN_TYPE_PC_BUD Character(3) VARCHAR2(3) NOT NULL Project resource analysis type for Grants

Default Value: BUD

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

106 PC_FTP_ROOT Character(254) VARCHAR2(254) NOT NULL FTP Server Directory

Default Value: C:\Inetpub\ftproot

107 PGM_DEPT_SPREAD Character(1) VARCHAR2(1) NOT NULL This is an installation level setting to allow the distribution of activity resource costs across departments when creating budgets from the Activity Resource List.
N=No Department Distribution
Y=Allow Department Distribution

Default Value: Y

108 AN_TYPE_PC_REV Character(3) VARCHAR2(3) NOT NULL Project resource analysis type for Grants

Default Value: RBD

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

109 AN_GRP_TOT_BIL Character(5) VARCHAR2(5) NOT NULL Analysis Group for Billing.

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

110 ASSET_APPROVAL Character(1) VARCHAR2(1) NOT NULL Review assets approval

Y/N Table Edit

Default Value: N

111 LAST_RATE_PLAN Number(15,0) DECIMAL(15) NOT NULL Track Last Rate Plan ID for Rate Plans.
112 SHARE_SW Character(1) VARCHAR2(1) NOT NULL Use Sharing

Y/N Table Edit

Default Value: N

113 AN_TYPE_ETB Character(3) VARCHAR2(3) NOT NULL Analysis Type - ETB

Default Value: ETB

Prompt Table: PROJ_ANTYPE_TBL

114 AN_TYPE_ETC Character(3) VARCHAR2(3) NOT NULL Analysis Type - ETC

Default Value: ETC

Prompt Table: PROJ_ANTYPE_TBL

115 CURRENCY_FLG Character(1) VARCHAR2(1) NOT NULL Currency Information Flag
D=Default from Higher Level
S=Specify at this Level

Y/N Table Edit

Default Value: N

116 AN_GRP_EAC Character(5) VARCHAR2(5) NOT NULL Analysis group representing the Estimate at Completion (a.k.a. Forecast).

Default Value: EAC

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

117 CAL_TYPE_WEEK Character(2) VARCHAR2(2) NOT NULL The calendar used for weekly reporting.

Default Value: WK

Prompt Table: CAL_DETL_VW
Set Control Field: ANALYSIS_SETID

118 AN_GRP_FREV Character(5) VARCHAR2(5) NOT NULL Forecast Revenue analysis group - contains all the analysis types that make up Forecast Revenue.

Default Value: FREV

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

119 AN_TYPE_SP_INC Character(3) VARCHAR2(3) NOT NULL SPro Assignment Incident

Default Value: INC

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

120 AN_TYPE_SP_LOG Character(3) VARCHAR2(3) NOT NULL SPro Progress Log

Default Value: SPL

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

121 UPD_THRESHOLD_SW Character(1) VARCHAR2(1) NOT NULL Update Threshold Amounts

Y/N Table Edit

Default Value: N

122 ONE_TARGET_SW Character(1) VARCHAR2(1) NOT NULL Group target definitions
N=No
Y=Yes

Y/N Table Edit

Default Value: N

123 ALLOW_REVERSAL Character(1) VARCHAR2(1) NOT NULL Allow Reversals
N=No
Y=Yes

Default Value: N

124 PC_FND_FEED_SW Character(1) VARCHAR2(1) NOT NULL Run for Incoming Transactions

Default Value: N

125 SUM_PRC Character(1) VARCHAR2(1) NOT NULL pricing summarization indicator

Y/N Table Edit

Default Value: N

126 SUM_VP Character(1) VARCHAR2(1) NOT NULL variance pricing summarization indicator

Y/N Table Edit

Default Value: N

127 SUM_APPO Character(1) VARCHAR2(1) NOT NULL payables & purchasing integration summarization indicator

Y/N Table Edit

Default Value: N

128 SUM_EX Character(1) VARCHAR2(1) NOT NULL expenses integration summarization indicator

Y/N Table Edit

Default Value: N

129 SUM_GL Character(1) VARCHAR2(1) NOT NULL general ledger integration summarization indicator

Y/N Table Edit

Default Value: N

130 SUM_TL Character(1) VARCHAR2(1) NOT NULL time and labor summarization indicator

Y/N Table Edit

Default Value: N

131 SUM_3RD Character(1) VARCHAR2(1) NOT NULL third party transaction integration summarization indicator

Y/N Table Edit

Default Value: N

132 SUM_PR Character(1) VARCHAR2(1) NOT NULL PROJ_RESOURCE reporting indicator

Default Value: N

133 AN_TYPE_FND_BAL Character(3) VARCHAR2(3) NOT NULL Balancing Analysis Type

Prompt Table: PROJ_ANTYPE_TBL
Set Control Field: ANALYSIS_SETID

134 AN_GRP_AR Character(5) VARCHAR2(5) NOT NULL Receivables Analysis Group

Default Value: AR

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

135 PC_MAX_BUD_ITEM Number(5,0) INTEGER NOT NULL Field to hold the max budget item fetched into the hgrid.
136 AN_GRP_BIL Character(5) VARCHAR2(5) NOT NULL Billing Analysis Group

Default Value: BI

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

137 MY_PRJ_SETUP Character(1) VARCHAR2(1) NOT NULL Set Up option for creating My Projects lists.
A=Auto Populate, No Overrides
M=Manual Identification by Users
O=Auto Populate, Allow Overrides

Default Value: M

138 MY_PRJ_SECURITY Character(1) VARCHAR2(1) NOT NULL Y/N indicator for populating My Projects using project security.

Y/N Table Edit

Default Value: N

139 MY_PRJ_ALL Character(1) VARCHAR2(1) NOT NULL Y/N indicator for populating My Projects using project team.

Y/N Table Edit

140 MY_PRJ_TEAM Character(1) VARCHAR2(1) NOT NULL Y/N indicator for populating My Projects using project team.

Y/N Table Edit

Default Value: N

141 MY_PRJ_TREE Character(1) VARCHAR2(1) NOT NULL Y/N indicator for populating My Projects using the default tree node from the user's preferences.

Y/N Table Edit

Default Value: N

142 MY_PRJ_GRANTS Character(1) VARCHAR2(1) NOT NULL Y/N indicator for populating My Projects using the Grants Portal project level security.

Y/N Table Edit

Default Value: N

143 MY_PRJ_INACTIVE Character(1) VARCHAR2(1) NOT NULL Y/N indicator for including inactive projects on users' My Projects lists.

Y/N Table Edit

Default Value: N

144 MY_PRJ_LASTUPDDTTM DateTime(26) TIMESTAMP Datetime stamp of when the My Projects auto populate process last ran.
145 PC_TOT_PER_QTY Number(10,0) DECIMAL(10) NOT NULL Total Period Quantity

Default Value: 4

146 ASSIGN_AN_TYPE_SW Character(1) VARCHAR2(1) NOT NULL Flag to indicate that the feature Assign GL Analysis Type is turned on or off.

Y/N Table Edit

Default Value: N

147 RESTRICT_ANTYPE_SW Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether the feature Restrict Analysis Types is enabled.

Y/N Table Edit

Default Value: N

148 SUPERUSER_ROLE Character(30) VARCHAR2(30) NOT NULL Superuser's User ID

Prompt Table: PSROLEDEFN_VW2

149 PC_CMP_SUPER_ROLE Character(30) VARCHAR2(30) NOT NULL PC Compression Super User Role

Prompt Table: PSROLEDEFN_VW2