SCC_SCRTY_AET

(SQL Table)
Index Back

Mass Sec Repl State Record

Used as the State record by the Mass Security Update program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 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

5 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

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

Prompt Table: %EDITTABLE

7 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

8 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
10 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
11 REPLACE_DFLT_OPRID Character(30) VARCHAR2(30) NOT NULL Default Replacement User

Prompt Table: CC_OPRDEFN_VW

12 REPLACE_OPRDEF_TBL Character(30) VARCHAR2(30) NOT NULL Operator Default Tbl CS

Prompt Table: CC_OPRDEFN_VW

13 REPLACE_INST Character(30) VARCHAR2(30) NOT NULL Institution

Prompt Table: CC_OPRDEFN_VW

14 REPLACE_INST_CMP Character(30) VARCHAR2(30) NOT NULL Institution/Campus

Prompt Table: CC_OPRDEFN_VW

15 REPLACE_INST_CAR Character(30) VARCHAR2(30) NOT NULL Institution/Career

Prompt Table: CC_OPRDEFN_VW

16 REPLACE_ACAD_PROG Character(30) VARCHAR2(30) NOT NULL Academic Program

Prompt Table: CC_OPRDEFN_VW

17 REPLACE_ACAD_PLAN Character(30) VARCHAR2(30) NOT NULL Academic Plan

Prompt Table: CC_OPRDEFN_VW

18 REPLACE_ACAD_ORG Character(30) VARCHAR2(30) NOT NULL Academic Organization

Prompt Table: CC_OPRDEFN_VW

19 REPLACE_APPL_CTR Character(30) VARCHAR2(30) NOT NULL Application Center

Prompt Table: CC_OPRDEFN_VW

20 REPLACE_RECR_CTR Character(30) VARCHAR2(30) NOT NULL Recruiting Center

Prompt Table: CC_OPRDEFN_VW

21 REPLACE_SRVC_IND Character(30) VARCHAR2(30) NOT NULL Service Indicator

Prompt Table: CC_OPRDEFN_VW

22 REPLACE_AIR Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default academic item registry security for a new oprid.
23 REPLACE_EVAL_MGMT Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default evaluation management security for a new oprid.
24 REPLACE_GRAD_STAT Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default graduation status security for a new oprid.
25 REPLACE_MLSTN Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default milestone security for a new oprid.
26 REPLACE_PDL_TRNS Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default CTM transaction security for a new oprid.
27 REPLACE_SCHED_ACTY Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default scheduled activity security for a new oprid.
28 REPLACE_TSCRPT_TYP Character(30) VARCHAR2(30) NOT NULL Transcript Type Security

Prompt Table: CC_OPRDEFN_VW

29 REPLACE_3C_GRP Character(30) VARCHAR2(30) NOT NULL 3C Group Security

Prompt Table: CC_OPRDEFN_VW

30 REPLACE_STDNT_GRP Character(30) VARCHAR2(30) NOT NULL Used on Oprid Security Replacement Record and Page.

Prompt Table: CC_OPRDEFN_VW

31 REPLACE_AA_RPT Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default advisement report security for a new oprid.

Prompt Table: CC_OPRDEFN_VW

32 REPLACE_ADM_ACTNS Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default admission actions security for a new oprid.

Prompt Table: CC_OPRDEFN_VW

33 REPLACE_POP_UPDATE Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default pop update security for a new oprid.

Prompt Table: CC_OPRDEFN_VW

34 REPLACE_PROG_ACTNS Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default program action security for a new oprid.

Prompt Table: CC_OPRDEFN_VW

35 REPLACE_TEST_ID Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default test id security for a new oprid.

Prompt Table: CC_OPRDEFN_VW

36 REPLACE_TSCRPT_RPT Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default transcript report security for a new oprid.

Prompt Table: CC_OPRDEFN_VW

37 REPLACE_APTACT Character(30) VARCHAR2(30) NOT NULL This field is used to identify the oprid from which to get the default academic item registry security for a new oprid.
38 EXIST Character(1) VARCHAR2(1) NOT NULL Currency Exist