CAN_RPT_CRSE

(SQL Table)
 Index Back

CAN course reporting fields

Canadian course reporting fields.

# 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 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 CAN_CRSE_CONTRCT Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
5 CAN_CRSE_WORK Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
6 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

Prompt Table: PROVINCE_VW

7 CAN_PROV_FUND_CD Character(6) VARCHAR2(6) NOT NULL * Sac-r75-19990831

Prompt Table: CAN_PROV_FNDCRS

8 CAN_ESIS_CR_COST Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
9 CAN_ESIS_CR_BROK Character(1) VARCHAR2(1) NOT NULL Brokered Course * Sac-r75-19990831
1=Yes-Institution is Sponsor
2=Yes- Institution is Host
3=No
9=Unknown