SSR_CRS_OFFR_ES (SQL Table)	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_ES

(SQL Table)

Course Catalog Offerings

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

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 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %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