SR_STAT_ZZ_VW

(SQL View)
Index Back

View of Stat Period Counts

This view displays a counter record for a student based on the values from the STDNT_CONS_STAT record. This is used for the SR Enrollment Cubes.

SELECT A.EMPLID , A.INSTITUTION , A.ACAD_STATS_PERIOD , B.SSR_COUNTER FROM PS_STDNT_CONS_STAT A , PS_SR_STAT_CT_VW B

# 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 ACAD_STATS_PERIOD Character(10) VARCHAR2(10) NOT NULL Academic Statistics Period
4 SSR_COUNTER Number(9,0) DECIMAL(9) NOT NULL This field is used by the view to create the SR enrollment cubes