STDNT_GRPS_CAF

(SQL Table)
Index Back

Student Groups History

CAF Recod for table that contains the history by effective date to which Groups a student belongs to.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group
4 EFFDT Date(10) DATE Effective Date
5 SCC_CAF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Attribute Sequence
6 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute

Prompt Table: %EDITTABLE18

7 SCC_CAF_ATTR_VAL Character(20) VARCHAR2(20) NOT NULL Attribute Value
8 SCC_CAF_ATTR_NVAL Number(32,11) DECIMAL(31,11) NOT NULL Numeric Value
9 SCC_CAF_ATTR_DVAL Date(10) DATE Date Value
10 SCC_CAF_ATTR_TVAL Character(50) VARCHAR2(50) NOT NULL Text Value
11 SCC_CAF_ATTR_TIME Time(15) TIMESTAMP Time Value
12 SCC_CAF_ATTR_YNO Character(1) VARCHAR2(1) NOT NULL Yes/No Value

Y/N Table Edit

13 SCC_CAF_ATTR_LVAL Long Character CLOB Long Text Value