RQ_ENT_GRP_DETL

(SQL Table)
Index Back

Entity group detail record

Record to store the Requirement group entity detail information.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RQ_ENTITY_GROUP Character(6) VARCHAR2(6) NOT NULL Academic Entity Group
2 EFFDT Date(10) DATE NOT NULL Effective Date
3 ENT_GRP_ITEM_NBR Number(3,0) SMALLINT NOT NULL Entity Group Item Number
4 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Prompt Table: ACAD_PROG_TBL

5 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

Prompt Table: ACAD_PLAN_TBL

6 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

Prompt Table: RQ_SUBPLN_VW

7 ACAD_STNDNG_STAT Character(4) VARCHAR2(4) NOT NULL Academic Standing Status
DIS=Dismissed
GST=Good Standing
PRO=Probation
SUB=Subject to Dismissal
8 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group

Prompt Table: SAA_STDGR_DTLVW

9 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: RQ_ENTITY_GROUP.INSTITUTION

Prompt Table: INSTITUTION_TBL