SAD_BR_CNSR_NLD

(SQL Table)
Index Back

BRON SnapshotRuncontrol record

BRONSnapshot Consolidation Runcontrol record

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTN_SCRTY

4 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode

Prompt Table: SCC_BRINCD_NLD

5 SAD_BR_EDU_SEC_NLD Character(2) VARCHAR2(2) NOT NULL Educational Sector
BO=Professional Education
ED=Education
VA=VAVO
6 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: SAD_BR_TERM_VW

7 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.

Y/N Table Edit

Default Value: Y

8 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool

Prompt Table: SCCPS_TOOL_VW

9 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

Prompt Table: %EDITTABLE

10 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

Prompt Table: SCCPS_CNTXT_VW

11 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
12 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
13 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
14 SAD_BR_CONS_DT_NLD Date(10) DATE Consolidation Date
15 CREATION_DT Date(10) DATE Creation Date
16 SAD_BR_SN_STAT_NLD Character(1) VARCHAR2(1) NOT NULL Status Snapshot
1=1st snapshot
2=2nd Snapshot
A=Actual snapshot
D=Final Snapshot
V=Provisional
V=Provisional
17 SAD_BR_WOFUNDI_NLD Character(1) VARCHAR2(1) NOT NULL Changes without Funding Impact

Y/N Table Edit

18 SAD_BR_ISGFNDI_NLD Character(1) VARCHAR2(1) NOT NULL ISG Changes wit Funding Impact

Y/N Table Edit

19 SAD_BR_EXNFNDI_NLD Character(1) VARCHAR2(1) NOT NULL EXN Funding Impact

Y/N Table Edit

20 SAD_BR_BPVFNDI_NLD Character(1) VARCHAR2(1) NOT NULL BPV Funding Impact

Y/N Table Edit

21 SAD_BR_ISGFND2_NLD Character(1) VARCHAR2(1) NOT NULL ISG 01-02 Funding Impacts

Y/N Table Edit

22 SAD_BR_UPD_ALL_NLD Character(1) VARCHAR2(1) NOT NULL Yes/No field fr runcontrol
23 TERM_BEGIN_DT Date(10) DATE Term Begin Date