STDNT_GRP_AET

(SQL Table)
Index Back

Student Group Batch State Rec

This is the main state record used in SCC_STD_GRP, the batch student group update process.

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
12 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group
13 ASOFDATE Date(10) DATE As of Date
14 SCC_EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
15 STDNT_OVRD Character(1) VARCHAR2(1) NOT NULL Student Override
16 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
17 EFFDT Date(10) DATE Effective Date
18 COMMENTS Long Character CLOB Comment
19 RECORD_COUNT Number(7,0) INTEGER NOT NULL Count of Records
20 TUIT_CALC_REQ_LBL Character(1) VARCHAR2(1) NOT NULL Tuition Calc Required