SSR_CS_INDX_GEN

(SQL Table)
Index Back

Class Search Index Action

This record is the run control header record for the Class Search Index Action Generator

# 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 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

4 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

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

Prompt Table: %EDITTABLE

6 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

7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
9 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
10 SSR_CS_IDX_ACTN Character(1) VARCHAR2(1) NOT NULL Class Data Action
A=Add Class
C=Change Class
D=Delete Class
S=Sync Class
11 SSR_CS_IDX_ADD Character(1) VARCHAR2(1) NOT NULL If Index Action Already Exists
C=Set Action to Change
N=Do not Add
12 SSR_CS_IDX_CHG Character(1) VARCHAR2(1) NOT NULL If Index Action Does Not Exist
A=Set Action to Add
N=Do not Change
13 SSR_DISABLE_RTI Character(1) VARCHAR2(1) NOT NULL Disable RTI
14 SSR_STATUS_RTI Character(1) VARCHAR2(1) NOT NULL RTI Status
15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time