STDNT_GRH_TAO (SQL Table)	Index Back
Student Groups History Temp Tb This temp table os a clone of the STDNT_GRPS_HIST table. It is used in the Applicaion Engine Program SCC_STD_GRP to hold duplicates.

STDNT_GRH_TAO

(SQL Table)

Student Groups History Temp Tb

This temp table os a clone of the STDNT_GRPS_HIST table. It is used in the Applicaion Engine Program SCC_STD_GRP to hold duplicates.

Parent record: STDNT_GRPS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTN_SCRTY

4 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group
Prompt Table: INST_STGPU_SCTY

5 EFFDT Date(10) DATE NOT NULL Effective Date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

7 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTN_SCRTY
4	STDNT_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Student Group Prompt Table: INST_STGPU_SCTY
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	COMMENTS	Long Character	CLOB	Comment