R_RQRMNT_GROUP

(SQL Table)
Index Back

requirement group report

Analysis table for academic advisement requirement group report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 RPT_DATE Date(10) DATE NOT NULL Report Date
3 RPT_TYPE Character(4) VARCHAR2(4) NOT NULL This field is the type of Academic Advisement report and is used by the tables in the Analysis Database. This field is reserved for use by SA.
SPC=Special Report
STD=Standard Report
4 ANALYSIS_DB_SEQ Number(4,0) SMALLINT NOT NULL Analysis DB Sequence

Default Value: 1

5 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

Prompt Table: RQ_GRP_TBL

6 RQ_DATE Date(10) DATE Requirement Date
7 ENTRY_R_STATUS Character(4) VARCHAR2(4) NOT NULL Item Status
COMP=Complete
EXMP=Exempted
FAIL=Fail
8 PARTITION_FAIL Character(1) VARCHAR2(1) NOT NULL Partition fail

Y/N Table Edit