S_NY_STU_PARTNERPRJTFACT_C ver 22.9.2
This table is a child table of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 22.9.2 | NUMBER(19,0) | Auto-generated number. Primary key. |
STUDENTSDCID | 22.9.2 | NUMBER(19,0) | The primary key that relates the extended table to the Students table. |
| SCHOOLYEAR | 22.9.2 | NUMBER(11,0) | School Year |
| PROJECTID | 22.9.2 | VARCHAR2(12) | Project ID |
| PROJECTSTARTDATE | 22.9.2 | DATE | Project Start Date |
| PROJECTENDDATE | 22.9.2 | DATE | Project End Date |
| LOCATIONCODE | 22.9.2 | VARCHAR2(6) | Location Code |
| PROGRAMCODE | 22.9.2 | VARCHAR2(8) | Program Code |
| SELCRITERIA1 | 22.9.2 | VARCHAR2(25) | Section Criteria 1 |
| SELCRITERIA2 | 22.9.2 | VARCHAR2(25) | Section Criteria 2 |
| SELCRITERIA3 | 22.9.2 | VARCHAR2(25) | Section Criteria 3 |
| SELCRITERIA4 | 22.9.2 | VARCHAR2(25) | Section Criteria 4 |
| SELCRITERIA5 | 22.9.2 | VARCHAR2(25) | Section Criteria 5 |
| PGRMDURATION | 22.9.2 | NUMBER(11,0) | Program Duration |
| ANNUALOUTCOMECODE | 22.9.2 | VARCHAR2(3) | Annual Outcome Code |
| ANNUALCREDSTATUS | 22.9.2 | VARCHAR2(3) | Annual Credential Status |
| INDPARTNER1 | 22.9.2 | VARCHAR2(50) | Industry Partner 1 Type |
| INDPARTNER2 | 22.9.2 | VARCHAR2(50) | Industry Partner 2 Type |
| INDPARTNER3 | 22.9.2 | VARCHAR2(50) | Industry Partner 3 Type |
| INDPARTNER4 | 22.9.2 | VARCHAR2(50) | Industry Partner 4 Type |
| CAREERPATHWAYCODE | 22.9.2 | VARCHAR2(10) | Career PathWay Code |
| INTERNSHIPTYPECODE | 22.9.2 | VARCHAR2(20) | Internship/Apprenticeship Name |
| PAIDINTERNSHIPIND | 22.9.2 | VARCHAR2(3) | Paid Internship Indicator |
| POSTPROJECTEMPNAME | 22.9.2 | VARCHAR2(50) | Post Collage Employer Name |
| POSTPROJECTJOBTITLE | 22.9.2 | VARCHAR2(50) | Post Collage Job Title |
| INDPARTNERNAME1 | 22.11.3 | VARCHAR2(100) | Industry Partner 1 Name |
| INDPARTNERNAME2 | 22.11.3 | VARCHAR2(100) | Industry Partner 2 Name |
| INDPARTNERNAME3 | 22.11.3 | VARCHAR2(100) | Industry Partner 3 Name |
| INDPARTNERNAME4 | 22.11.3 | VARCHAR2(100) | Industry Partner 4 Name |