SCC_SCRTY_AET(SQL Table) |
Index Back |
---|---|
Mass Sec Repl State RecordUsed 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 |