| # |
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 |
CRSE_OFFER_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Course Offering Nbr
|
| 4 |
SSR_HECS_BAND_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
HECS Band ID
Default Value: SSR_SUBJECT_AUS.SSR_HECS_BAND_ID
Prompt Table:
SSR_HECSBND_AUS
|
| 5 |
SSR_USE_PLAN_DISCI |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Discipline Group From Plan
Y/N Table Edit
Default Value: N
|
| 6 |
SSR_DISCP_GROUP_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Discipline Group Code
Default Value: SSR_SUBJECT_AUS.SSR_DISCP_GROUP_CD
Prompt Table:
SSR_DSCP_CD_TBL
|
| 7 |
SSR_FLD_OF_EDUCATN |
Character(8) |
VARCHAR2(8) NOT NULL |
SCS SA LTRA8N2 Created.
Default Value: SSR_SUBJECT_AUS.SSR_FLD_OF_EDUCATN
Prompt Table:
SSR_FOE_TBL
|
| 8 |
SSR_WORK_EXP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Work experience indicator
0=Not Wholly Work Experience
1=Wholly Work Exp with Charge
2=Wholly Work Exp - Exempt
Default Value: 0
|
| 9 |
SSR_CRSE_SUMMR_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Summer School Full Fee Ind.
2=Full-fee summer school
3=Full-fee winter school
|
| 10 |
SSR_YR_LONG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Year long indicator (HEIMS)
Y/N Table Edit
Default Value: N
|
| 11 |
SSR_EXCL_FRM_HEIMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude From HEIMS (HEIMS)
Y/N Table Edit
Default Value: N
|
| 12 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 13 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 14 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 15 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|