| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 3 |
ACAD_STATS_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Statistics Period
Prompt Table:
STAT_PERIOD_TBL
|
| 4 |
SSR_NSC_PRG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is the calculated value for the NSC program indicator for the new NSC reporting requirements for 2014. Currently this value will always be set to Y.
|
| 5 |
SSR_NSC_PRG1_CIPCD |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report a CIP code for a specific program in NSC reporting.
|
| 6 |
SSR_NSC_PRG1_CIPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to report the year a CIP code was published for a specific program in NSC reporting.
|
| 7 |
SSR_NSC_PRG1_CRLVL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is the calculated value for the NSC program indicator for the new NSC reporting requirements for 2014. Currently this value will always be set to Y.
01=Undergrad Diploma/Cert
02=Associate Degree
03=Bachelor's Degree
04=Post Baccalaureate Certificate
05=Master's Degree
06=Doctoral Degree
07=First Professional Degree
08=Graduate/Professional Certif
99=Non-credential Programs
|
| 8 |
SSR_NSC_PRG1_LNGTH |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report published length of time it takes to complete a specific program in NSC reporting.
|
| 9 |
SSR_NSC_PRG1_LENCD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report published length of time code in NSC reporting.
M=Months
W=Weeks
Y=Years
|
| 10 |
SSR_NSC_PRG1_TT4YR |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report the Title IV academic year for a specific program in NSC reporting.
|
| 11 |
SSR_NSC_PRG1_BGNDT |
Date(10) |
DATE |
This field is used to report the begin date for a specific program in NSC reporting.
|
| 12 |
SSR_NSC_PRG1_SPIND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report special indicator code for a program in NSC reporting.
A=Selective Admission Assoc Deg
B=2-year Bachelor's Degree
N=Not Applicable
P=Prep Crsewk Grad Prof Pgm
T=Non-Cred Teacher Cert Pgm
U=Prep Crsewk Ugrad Program
|
| 13 |
SSR_NSC_PRG1_ENRST |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report enrollment status code for a program in NSC reporting.
A=Leave of Absence
D=Deceased
F=Full Time
G=Graduated
H=Half Time
L=Less Than Half Time
Q=Three Quarter Time
W=Withdrawn
|
| 14 |
SSR_NSC_PRG1_ENRDT |
Date(10) |
DATE |
This field is used to report enrollment status code effective date for a program in NSC reporting.
|
| 15 |
SSR_NSC_PRG1_DTADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to identify if program enrollment status date has been adjusted.
|
| 16 |
SSR_NSC_PRG1_USEDT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field idetntifies if program enrollment status date has been adjusted and use the date from previous run.
|
| 17 |
SSR_NSC_PRG1_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Status indicator for NSC Data Elements Table - Program 1.
A=Date Based on As Of Date
E=Date Based On Enrollment Data
F=Same CIP Found
I=Incomplete Data
M=Same CIP Merged
S=Success
T=Date Based on Term Data
|
| 18 |
SSR_NSC_PRG2_CIPCD |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report a CIP code for a specific program in NSC reporting.
|
| 19 |
SSR_NSC_PRG2_CIPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to report the year a CIP code was published for a specific program in NSC reporting.
|
| 20 |
SSR_NSC_PRG2_CRLVL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is the calculated value for the NSC program indicator for the new NSC reporting requirements for 2014. Currently this value will always be set to Y.
01=Undergrad Diploma/Cert
02=Associate Degree
03=Bachelor's Degree
04=Post Baccalaureate Certificate
05=Master's Degree
06=Doctoral Degree
07=First Professional Degree
08=Graduate/Professional Certif
99=Non-credential Programs
|
| 21 |
SSR_NSC_PRG2_LNGTH |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report published length of time it takes to complete a specific program in NSC reporting.
|
| 22 |
SSR_NSC_PRG2_LENCD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report published length of time code in NSC reporting.
M=Months
W=Weeks
Y=Years
|
| 23 |
SSR_NSC_PRG2_TT4YR |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report the Title IV academic year for a specific program in NSC reporting.
|
| 24 |
SSR_NSC_PRG2_BGNDT |
Date(10) |
DATE |
This field is used to report the begin date for a specific program in NSC reporting.
|
| 25 |
SSR_NSC_PRG2_SPIND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report special indicator code for a program in NSC reporting.
A=Selective Admission Assoc Deg
B=2-year Bachelor's Degree
N=Not Applicable
P=Prep Crsewk Grad Prof Pgm
T=Non-Cred Teacher Cert Pgm
U=Prep Crsewk Ugrad Program
|
| 26 |
SSR_NSC_PRG2_ENRST |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report enrollment status code for a program in NSC reporting.
A=Leave of Absence
D=Deceased
F=Full Time
G=Graduated
H=Half Time
L=Less Than Half Time
Q=Three Quarter Time
W=Withdrawn
|
| 27 |
SSR_NSC_PRG2_ENRDT |
Date(10) |
DATE |
This field is used to report enrollment status code effective date for a program in NSC reporting.
|
| 28 |
SSR_NSC_PRG2_DTADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to identify if program enrollment status date has been adjusted.
|
| 29 |
SSR_NSC_PRG2_USEDT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field idetntifies if program enrollment status date has been adjusted and use the date from previous run.
|
| 30 |
SSR_NSC_PRG2_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Status indicator for NSC Data Elements Table - Program 2.
|
| 31 |
SSR_NSC_PRG3_CIPCD |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report a CIP code for a specific program in NSC reporting.
|
| 32 |
SSR_NSC_PRG3_CIPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to report the year a CIP code was published for a specific program in NSC reporting.
|
| 33 |
SSR_NSC_PRG3_CRLVL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is the calculated value for the NSC program indicator for the new NSC reporting requirements for 2014. Currently this value will always be set to Y.
01=Undergrad Diploma/Cert
02=Associate Degree
03=Bachelor's Degree
04=Post Baccalaureate Certificate
05=Master's Degree
06=Doctoral Degree
07=First Professional Degree
08=Graduate/Professional Certif
99=Non-credential Programs
|
| 34 |
SSR_NSC_PRG3_LNGTH |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report published length of time it takes to complete a specific program in NSC reporting.
|
| 35 |
SSR_NSC_PRG3_LENCD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report published length of time code in NSC reporting.
M=Months
W=Weeks
Y=Years
|
| 36 |
SSR_NSC_PRG3_TT4YR |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report the Title IV academic year for a specific program in NSC reporting.
|
| 37 |
SSR_NSC_PRG3_BGNDT |
Date(10) |
DATE |
This field is used to report the begin date for a specific program in NSC reporting.
|
| 38 |
SSR_NSC_PRG3_SPIND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report special indicator code for a program in NSC reporting.
A=Selective Admission Assoc Deg
B=2-year Bachelor's Degree
N=Not Applicable
P=Prep Crsewk Grad Prof Pgm
T=Non-Cred Teacher Cert Pgm
U=Prep Crsewk Ugrad Program
|
| 39 |
SSR_NSC_PRG3_ENRST |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report enrollment status code for a program in NSC reporting.
A=Leave of Absence
D=Deceased
F=Full Time
G=Graduated
H=Half Time
L=Less Than Half Time
Q=Three Quarter Time
W=Withdrawn
|
| 40 |
SSR_NSC_PRG3_ENRDT |
Date(10) |
DATE |
This field is used to report enrollment status code effective date for a program in NSC reporting.
|
| 41 |
SSR_NSC_PRG3_DTADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to identify if program enrollment status date has been adjusted.
|
| 42 |
SSR_NSC_PRG3_USEDT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field idetntifies if program enrollment status date has been adjusted and use the date from previous run.
|
| 43 |
SSR_NSC_PRG3_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Status indicator for NSC Data Elements Table - Program 3.
|
| 44 |
SSR_NSC_PRG4_CIPCD |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report a CIP code for a specific program in NSC reporting.
|
| 45 |
SSR_NSC_PRG4_CIPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to report the year a CIP code was published for a specific program in NSC reporting.
|
| 46 |
SSR_NSC_PRG4_CRLVL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is the calculated value for the NSC program indicator for the new NSC reporting requirements for 2014. Currently this value will always be set to Y.
01=Undergrad Diploma/Cert
02=Associate Degree
03=Bachelor's Degree
04=Post Baccalaureate Certificate
05=Master's Degree
06=Doctoral Degree
07=First Professional Degree
08=Graduate/Professional Certif
99=Non-credential Programs
|
| 47 |
SSR_NSC_PRG4_LNGTH |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report published length of time it takes to complete a specific program in NSC reporting.
|
| 48 |
SSR_NSC_PRG4_LENCD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report published length of time code in NSC reporting.
M=Months
W=Weeks
Y=Years
|
| 49 |
SSR_NSC_PRG4_TT4YR |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report the Title IV academic year for a specific program in NSC reporting.
|
| 50 |
SSR_NSC_PRG4_BGNDT |
Date(10) |
DATE |
This field is used to report the begin date for a specific program in NSC reporting.
|
| 51 |
SSR_NSC_PRG4_SPIND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report special indicator code for a program in NSC reporting.
A=Selective Admission Assoc Deg
B=2-year Bachelor's Degree
N=Not Applicable
P=Prep Crsewk Grad Prof Pgm
T=Non-Cred Teacher Cert Pgm
U=Prep Crsewk Ugrad Program
|
| 52 |
SSR_NSC_PRG4_ENRST |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report enrollment status code for a program in NSC reporting.
A=Leave of Absence
D=Deceased
F=Full Time
G=Graduated
H=Half Time
L=Less Than Half Time
Q=Three Quarter Time
W=Withdrawn
|
| 53 |
SSR_NSC_PRG4_ENRDT |
Date(10) |
DATE |
This field is used to report enrollment status code effective date for a program in NSC reporting.
|
| 54 |
SSR_NSC_PRG4_DTADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to identify if program enrollment status date has been adjusted.
|
| 55 |
SSR_NSC_PRG4_USEDT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field idetntifies if program enrollment status date has been adjusted and use the date from previous run.
|
| 56 |
SSR_NSC_PRG4_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Status indicator for NSC Data Elements Table - Program 4.
|
| 57 |
SSR_NSC_PRG5_CIPCD |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report a CIP code for a specific program in NSC reporting.
|
| 58 |
SSR_NSC_PRG5_CIPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to report the year a CIP code was published for a specific program in NSC reporting.
|
| 59 |
SSR_NSC_PRG5_CRLVL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is the calculated value for the NSC program indicator for the new NSC reporting requirements for 2014. Currently this value will always be set to Y.
01=Undergrad Diploma/Cert
02=Associate Degree
03=Bachelor's Degree
04=Post Baccalaureate Certificate
05=Master's Degree
06=Doctoral Degree
07=First Professional Degree
08=Graduate/Professional Certif
99=Non-credential Programs
|
| 60 |
SSR_NSC_PRG5_LNGTH |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report published length of time it takes to complete a specific program in NSC reporting.
|
| 61 |
SSR_NSC_PRG5_LENCD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report published length of time code in NSC reporting.
M=Months
W=Weeks
Y=Years
|
| 62 |
SSR_NSC_PRG5_TT4YR |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report the Title IV academic year for a specific program in NSC reporting.
|
| 63 |
SSR_NSC_PRG5_BGNDT |
Date(10) |
DATE |
This field is used to report the begin date for a specific program in NSC reporting.
|
| 64 |
SSR_NSC_PRG5_SPIND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report special indicator code for a program in NSC reporting.
A=Selective Admission Assoc Deg
B=2-year Bachelor's Degree
N=Not Applicable
P=Prep Crsewk Grad Prof Pgm
T=Non-Cred Teacher Cert Pgm
U=Prep Crsewk Ugrad Program
|
| 65 |
SSR_NSC_PRG5_ENRST |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report enrollment status code for a program in NSC reporting.
A=Leave of Absence
D=Deceased
F=Full Time
G=Graduated
H=Half Time
L=Less Than Half Time
Q=Three Quarter Time
W=Withdrawn
|
| 66 |
SSR_NSC_PRG5_ENRDT |
Date(10) |
DATE |
This field is used to report enrollment status code effective date for a program in NSC reporting.
|
| 67 |
SSR_NSC_PRG5_DTADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to identify if program enrollment status date has been adjusted.
|
| 68 |
SSR_NSC_PRG5_USEDT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field idetntifies if program enrollment status date has been adjusted and use the date from previous run.
|
| 69 |
SSR_NSC_PRG5_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Status indicator for NSC Data Elements Table - Program 5.
|
| 70 |
SSR_NSC_PRG6_CIPCD |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report a CIP code for a specific program in NSC reporting.
|
| 71 |
SSR_NSC_PRG6_CIPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to report the year a CIP code was published for a specific program in NSC reporting.
|
| 72 |
SSR_NSC_PRG6_CRLVL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is the calculated value for the NSC program indicator for the new NSC reporting requirements for 2014. Currently this value will always be set to Y.
01=Undergrad Diploma/Cert
02=Associate Degree
03=Bachelor's Degree
04=Post Baccalaureate Certificate
05=Master's Degree
06=Doctoral Degree
07=First Professional Degree
08=Graduate/Professional Certif
99=Non-credential Programs
|
| 73 |
SSR_NSC_PRG6_LNGTH |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report published length of time it takes to complete a specific program in NSC reporting.
|
| 74 |
SSR_NSC_PRG6_LENCD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report published length of time code in NSC reporting.
M=Months
W=Weeks
Y=Years
|
| 75 |
SSR_NSC_PRG6_TT4YR |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to report the Title IV academic year for a specific program in NSC reporting.
|
| 76 |
SSR_NSC_PRG6_BGNDT |
Date(10) |
DATE |
This field is used to report the begin date for a specific program in NSC reporting.
|
| 77 |
SSR_NSC_PRG6_SPIND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report special indicator code for a program in NSC reporting.
A=Selective Admission Assoc Deg
B=2-year Bachelor's Degree
N=Not Applicable
P=Prep Crsewk Grad Prof Pgm
T=Non-Cred Teacher Cert Pgm
U=Prep Crsewk Ugrad Program
|
| 78 |
SSR_NSC_PRG6_ENRST |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to report enrollment status code for a program in NSC reporting.
A=Leave of Absence
D=Deceased
F=Full Time
G=Graduated
H=Half Time
L=Less Than Half Time
Q=Three Quarter Time
W=Withdrawn
|
| 79 |
SSR_NSC_PRG6_ENRDT |
Date(10) |
DATE |
This field is used to report enrollment status code effective date for a program in NSC reporting.
|
| 80 |
SSR_NSC_PRG6_DTADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to identify if program enrollment status date has been adjusted.
|
| 81 |
SSR_NSC_PRG6_USEDT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field idetntifies if program enrollment status date has been adjusted and use the date from previous run.
|
| 82 |
SSR_NSC_PRG6_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Status indicator for NSC Data Elements Table - Program 6.
|
| 83 |
SSR_NSC_OVRD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Indicator
Y/N Table Edit
|
| 84 |
SSR_NSC_STAT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Status indicator for NSC Data Elements Table.
M=Message
S=Success
|
| 85 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 86 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 87 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 88 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|