INSTALLATION_GM

(SQL Table)
 Index Back

System Options - GM

System Options - GM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LAST_PROTOCOL_ID Number(15,0) DECIMAL(15) NOT NULL Last Protocol ID

Default Value: 1000

2 GM_SUBMISSION Character(1) VARCHAR2(1) NOT NULL Enable Electronic Submission

Default Value: N

3 BUDGET_ID Character(15) VARCHAR2(15) NOT NULL BUDGET_ID
4 OPTION_ATT Character(1) VARCHAR2(1) NOT NULL Include Optional Attachments

Y/N Table Edit

Default Value: N

5 GM_PT_SOURCE Character(4) VARCHAR2(4) NOT NULL Transaction Source
KK=Commitment Control
PC=Project

Default Value: PC

6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GM_PT_ACCT_VW

7 BUD_OVERLAP_SW Character(1) VARCHAR2(1) NOT NULL Overlap Award Budget Period
F=First
L=Last

Default Value: F

8 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID

Prompt Table: SP_SETID_NONVW

9 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: GM_PT_TREE_VW
Set Control Field: TREE_SETID

10 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record

Prompt Table: GM_PT_TREELVL_V

11 SPONSOR_EXPD Character(5) VARCHAR2(5) NOT NULL Sponsor Expenditures

Default Value: SPACT

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

12 COST_SHARE_EXPD Character(5) VARCHAR2(5) NOT NULL Cost Share Expenditures

Default Value: CSTSH

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

13 SPONSOR_ENCB Character(5) VARCHAR2(5) NOT NULL Sponsor Encumbrances

Default Value: SPENC

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

14 COST_SHARE_ENCB Character(5) VARCHAR2(5) NOT NULL Cost Share Encumbrances

Default Value: CSCOM

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

15 SPONSOR_PREENCB Character(5) VARCHAR2(5) NOT NULL Sponsor Pre-encumbrances

Default Value: SPREQ

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

16 COST_SHARE_PREENCB Character(5) VARCHAR2(5) NOT NULL Cost Share Pre-encumbrances

Default Value: CRQ

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

17 THIRDPARTY_EXPD Character(5) VARCHAR2(5) NOT NULL Third Party Expenditures

Prompt Table: PROJ_AN_GRP_TBL
Set Control Field: ANALYSIS_SETID

18 BUDGET_GROUP_BY Character(18) VARCHAR2(18) NOT NULL Budget Group by

Prompt Table: %EDITTABLE

19 PC_OR_KK_FLG Character(1) VARCHAR2(1) NOT NULL Projects or Commitment Control
K=Commitment Control
P=Projects

Default Value: P