CAN_RPT_ESIS_IP (SQL Table)	Index Back
ESIS Institution Program File SAC-R75-19990831

CAN_RPT_ESIS_IP

(SQL Table)

ESIS Institution Program File

SAC-R75-19990831

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 CAN_RPT_ESIS_PROG Character(20) VARCHAR2(20) NOT NULL SAC-R75-19990831

3 CAN_ESIS_START_YR Number(4,0) SMALLINT NOT NULL Report Start Year SAC-R75-19990831

4 CAN_GOV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL Institution Code Sac-r75-19990831
Prompt Table: CAN_GOV_SCHOOL

5 CAN_PROG_CRED_TYP Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
01=General Equivalency
02=Certificate
03=Diploma
04=Degree
05=Declaration of Achievement
06=Other PostSecondary
07=Other Non-PostSecondary
08=Other Undergraduate Level
09=Other Graduate Level
10=Attest and Other Short Prog
11=Associate Degree
96=Other Type of Credential
97=Other Type of Credential
98=Not Applicable

6 CAN_PROG_JOINT_TYP Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
01=General Equivalency
02=Certificate
03=Diploma
04=Degree
05=Declaration of Achievement
06=Other PostSecondary
07=Other Non PostSecondary
08=Other Undergraduate Level
09=Other Graduate Level
10=Attest and Other Short Prog
11=Associate Degree
96=Other Type of Credential
97=Other Type of Credential
98=Not Applicable

7 CAN_PROG_PROG_LVL Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831

8 CAN_PROG_JOINT_LVL Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831

9 CAN_PROG_PGM_DESCR Character(100) VARCHAR2(100) NOT NULL SAC-R75-19990831

10 CAN_PROV_PROG_CAT Character(8) VARCHAR2(8) NOT NULL * Sac-r75-19990831
Prompt Table: CAN_PROV_PROG

11 CAN_PROV_FUND_CD Character(6) VARCHAR2(6) NOT NULL * Sac-r75-19990831
Prompt Table: CAN_PROV_FUND

12 CAN_PROG_HOURS Number(5,0) INTEGER NOT NULL SAC-R75-19990831

13 CAN_PROG_DURATION Number(7,2) DECIMAL(6,2) NOT NULL Program Duration SAC-R75-19990831

14 CAN_PROG_DUR_UNIT Character(2) VARCHAR2(2) NOT NULL Duration Units SAC-R75-19990831
08=Weeks
09=Months
10=Half-Semesters
15=Semesters or Trimesters
25=Academic Years
30=Years
98=Not Applicable

15 CAN_PROG_CREDIT Number(9,2) DECIMAL(8,2) NOT NULL SAC-R75-19990831

16 CAN_PROG_CRED_UNIT Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
01=Credits
02=Credit Hours
03=Semester Hours
04=Course Hours
05=Credit Points
06=Courses
07=Student Contact Hours
96=Other Units
98=Not Applicable

17 CAN_PROG_SESS_TYPE Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
05=Summer Sessions Only
07=Intersessions Only
08=Weeks
09=Months
10=Quarters
15=Semesters or Trimesters
25=Academic Years(8 months)
30=Years (12 months)
96=Other
98=Not Applicable

18 CAN_PROG_FULL_PART Character(1) VARCHAR2(1) NOT NULL SAC-R75-19990831
1=Offered on FullTime Basis Only
2=Offered on PartTime Basis Only
3=Offered Full Time or Part Time
8=Not Applicable
9=Unknown

19 CAN_PROG_EDU_ENT Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
13=High School Diploma
14=High School Matriculation
18=Some Secondary Education
19=Primary/Elementary Education
21=Registered Apprenticeship
22=Trade/Vocational Certificate
23=College PostSecond Certificate
24=College PostSecondary Diploma
28=Other College Level
29=Non-Prof Health Certif
41=Bachelor's Degree
42=First Prof Degree
46=Undergraduate Certificate
47=Undergraduate Dilpoma
48=Other Undergraduate Credential
49=Some Udergraduate Level
51=Master's Degree
52=Graduate Level Certificate
53=Graduate Level Diploma
54=Ph.D
55=Equivalent Earned Doctorate
58=Other Graduate Credential
59=Some Graduate Level
96=Other Level
98=No Entrance Requirement
99=Unknown

20 CAN_PROG_LEG_ENT Character(1) VARCHAR2(1) NOT NULL SAC-R75-19990831
1=Yes
2=No
8=No Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

21 CAN_PROG_MED_ENT Character(1) VARCHAR2(1) NOT NULL SAC-R75-19990831
1=Yes
2=No
8=No Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

22 CAN_PROG_APT_ENT Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

23 CAN_PROG_EXP_ENT Character(1) VARCHAR2(1) NOT NULL Experience Requirement Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

24 CAN_PROG_OTH_ENT Character(1) VARCHAR2(1) NOT NULL Other Requirement Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

25 CAN_PROG_CONTRACT Character(1) VARCHAR2(1) NOT NULL Contract Delivery Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

26 CAN_PROG_LIM_ENRL Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes-Institution Set Limit
2=Yes-Professional Org Set Limit
3=Yes-Government Set Limit
6=No
8=Not Applicable
9=Unknown

27 CAN_PROG_CAPACITY Number(5,0) INTEGER NOT NULL Sac-r75-19990831

28 CAN_PROG_MAN_PD Number(9,2) DECIMAL(8,2) NOT NULL Sac-r75-19990831

29 CAN_PROG_MAN_UNIT Character(2) VARCHAR2(2) NOT NULL Sac-r75-19990831
06=Hours
07=Days
08=Weeks
09=Months
10=Half-Semesters
15=Semesters or Trimesters
25=Academic Years
30=Years
96=Other Units
97=OJT Category Unknown
98=Not Applicable
99=Duration Unknown

30 CAN_PROG_OPT_PD Number(9,2) DECIMAL(8,2) NOT NULL Opt Paid OJT Dur Sac-r75-19990831

31 CAN_PROG_OPT_UNIT Character(2) VARCHAR2(2) NOT NULL Sac-r75-19990831
06=Hours
07=Days
08=Weeks
09=Months
10=Half-Semesters
15=Semesters or Trimesters
25=Academic Years
30=Years
96=Other Units
97=OJT Category Unknown
98=Not Applicable
99=Duration Unknown

32 CAN_PROG_MAN_UPD Number(9,2) DECIMAL(8,2) NOT NULL Sac-r75-19990831

33 CAN_PROG_MANU_UNIT Character(2) VARCHAR2(2) NOT NULL Man. Unpaid OJT Duration Units Sac-r75-19990831
06=Hours
07=Days
08=Weeks
09=Months
10=Half-Semesters
15=Semesters or Trimesters
25=Academic Years
30=Years
96=Other Units
97=OJT Category Unknown
98=Not Applicable
99=Duration Unknown

34 CAN_PROG_OPT_UPD Number(9,2) DECIMAL(8,2) NOT NULL Sac-r75-19990831

35 CAN_PROG_OPTU_UNIT Character(2) VARCHAR2(2) NOT NULL Optional Unpaid OJT Dur Units Sac-r75-19990831
06=Hours
07=Days
08=Weeks
09=Months
10=Half-Semesters
15=Semesters or Trimesters
25=Academic Years
30=Years
96=Other Units
97=OJT Duration Unknown
98=Not Applicable
99=Duration unknown

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	CAN_RPT_ESIS_PROG	Character(20)	VARCHAR2(20) NOT NULL	SAC-R75-19990831
3	CAN_ESIS_START_YR	Number(4,0)	SMALLINT NOT NULL	Report Start Year SAC-R75-19990831
4	CAN_GOV_SCHOOL_CD	Character(15)	VARCHAR2(15) NOT NULL	Institution Code Sac-r75-19990831 Prompt Table: CAN_GOV_SCHOOL
5	CAN_PROG_CRED_TYP	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 01=General Equivalency 02=Certificate 03=Diploma 04=Degree 05=Declaration of Achievement 06=Other PostSecondary 07=Other Non-PostSecondary 08=Other Undergraduate Level 09=Other Graduate Level 10=Attest and Other Short Prog 11=Associate Degree 96=Other Type of Credential 97=Other Type of Credential 98=Not Applicable
6	CAN_PROG_JOINT_TYP	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 01=General Equivalency 02=Certificate 03=Diploma 04=Degree 05=Declaration of Achievement 06=Other PostSecondary 07=Other Non PostSecondary 08=Other Undergraduate Level 09=Other Graduate Level 10=Attest and Other Short Prog 11=Associate Degree 96=Other Type of Credential 97=Other Type of Credential 98=Not Applicable
7	CAN_PROG_PROG_LVL	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831
8	CAN_PROG_JOINT_LVL	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831
9	CAN_PROG_PGM_DESCR	Character(100)	VARCHAR2(100) NOT NULL	SAC-R75-19990831
10	CAN_PROV_PROG_CAT	Character(8)	VARCHAR2(8) NOT NULL	* Sac-r75-19990831 Prompt Table: CAN_PROV_PROG
11	CAN_PROV_FUND_CD	Character(6)	VARCHAR2(6) NOT NULL	* Sac-r75-19990831 Prompt Table: CAN_PROV_FUND
12	CAN_PROG_HOURS	Number(5,0)	INTEGER NOT NULL	SAC-R75-19990831
13	CAN_PROG_DURATION	Number(7,2)	DECIMAL(6,2) NOT NULL	Program Duration SAC-R75-19990831
14	CAN_PROG_DUR_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Duration Units SAC-R75-19990831 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 98=Not Applicable
15	CAN_PROG_CREDIT	Number(9,2)	DECIMAL(8,2) NOT NULL	SAC-R75-19990831
16	CAN_PROG_CRED_UNIT	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 01=Credits 02=Credit Hours 03=Semester Hours 04=Course Hours 05=Credit Points 06=Courses 07=Student Contact Hours 96=Other Units 98=Not Applicable
17	CAN_PROG_SESS_TYPE	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 05=Summer Sessions Only 07=Intersessions Only 08=Weeks 09=Months 10=Quarters 15=Semesters or Trimesters 25=Academic Years(8 months) 30=Years (12 months) 96=Other 98=Not Applicable
18	CAN_PROG_FULL_PART	Character(1)	VARCHAR2(1) NOT NULL	SAC-R75-19990831 1=Offered on FullTime Basis Only 2=Offered on PartTime Basis Only 3=Offered Full Time or Part Time 8=Not Applicable 9=Unknown
19	CAN_PROG_EDU_ENT	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 13=High School Diploma 14=High School Matriculation 18=Some Secondary Education 19=Primary/Elementary Education 21=Registered Apprenticeship 22=Trade/Vocational Certificate 23=College PostSecond Certificate 24=College PostSecondary Diploma 28=Other College Level 29=Non-Prof Health Certif 41=Bachelor's Degree 42=First Prof Degree 46=Undergraduate Certificate 47=Undergraduate Dilpoma 48=Other Undergraduate Credential 49=Some Udergraduate Level 51=Master's Degree 52=Graduate Level Certificate 53=Graduate Level Diploma 54=Ph.D 55=Equivalent Earned Doctorate 58=Other Graduate Credential 59=Some Graduate Level 96=Other Level 98=No Entrance Requirement 99=Unknown
20	CAN_PROG_LEG_ENT	Character(1)	VARCHAR2(1) NOT NULL	SAC-R75-19990831 1=Yes 2=No 8=No Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
21	CAN_PROG_MED_ENT	Character(1)	VARCHAR2(1) NOT NULL	SAC-R75-19990831 1=Yes 2=No 8=No Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
22	CAN_PROG_APT_ENT	Character(1)	VARCHAR2(1) NOT NULL	Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
23	CAN_PROG_EXP_ENT	Character(1)	VARCHAR2(1) NOT NULL	Experience Requirement Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
24	CAN_PROG_OTH_ENT	Character(1)	VARCHAR2(1) NOT NULL	Other Requirement Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
25	CAN_PROG_CONTRACT	Character(1)	VARCHAR2(1) NOT NULL	Contract Delivery Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
26	CAN_PROG_LIM_ENRL	Character(1)	VARCHAR2(1) NOT NULL	Sac-r75-19990831 1=Yes-Institution Set Limit 2=Yes-Professional Org Set Limit 3=Yes-Government Set Limit 6=No 8=Not Applicable 9=Unknown
27	CAN_PROG_CAPACITY	Number(5,0)	INTEGER NOT NULL	Sac-r75-19990831
28	CAN_PROG_MAN_PD	Number(9,2)	DECIMAL(8,2) NOT NULL	Sac-r75-19990831
29	CAN_PROG_MAN_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units 97=OJT Category Unknown 98=Not Applicable 99=Duration Unknown
30	CAN_PROG_OPT_PD	Number(9,2)	DECIMAL(8,2) NOT NULL	Opt Paid OJT Dur Sac-r75-19990831
31	CAN_PROG_OPT_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units 97=OJT Category Unknown 98=Not Applicable 99=Duration Unknown
32	CAN_PROG_MAN_UPD	Number(9,2)	DECIMAL(8,2) NOT NULL	Sac-r75-19990831
33	CAN_PROG_MANU_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Man. Unpaid OJT Duration Units Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units 97=OJT Category Unknown 98=Not Applicable 99=Duration Unknown
34	CAN_PROG_OPT_UPD	Number(9,2)	DECIMAL(8,2) NOT NULL	Sac-r75-19990831
35	CAN_PROG_OPTU_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Optional Unpaid OJT Dur Units Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units 97=OJT Duration Unknown 98=Not Applicable 99=Duration unknown