SSR_CRS_OFFR_V2 (SQL View)	Index Back
Course Catalog Offerings The Course Catalog Offerings indicates what academic units, subject and course catalog numbers a course can be offered under.

SSR_CRS_OFFR_V2

(SQL View)

Course Catalog Offerings

The Course Catalog Offerings indicates what academic units, subject and course catalog numbers a course can be offered under.

SELECT A.CRSE_ID , A.CRSE_OFFER_NBR , A.EFFDT , A.LAST_UPDATE_DTTM , A.AUDIT_ACTN FROM PS_SSR_CRS_OFFR_E2 A

Parent record: CRSE_CATALOG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
Prompt Table: CRSE_CATALOG

2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

3 SSR_WORK_DT Date(10) DATE Student Records Work Date

4 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

5 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID Prompt Table: CRSE_CATALOG
2	CRSE_OFFER_NBR	Number(2,0)	SMALLINT NOT NULL	Course Offering Nbr
3	SSR_WORK_DT	Date(10)	DATE	Student Records Work Date
4	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
5	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values