SAD_CFI_LD_NLD(SQL Table) |
Index Back |
|---|---|
CFI load TableLoad table used by CFI file load process. Table lay-out should correspond with the file layout. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACAD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Academic Year |
| 2 | SSR_CORRSPN_NR_NLD | Character(12) | VARCHAR2(12) NOT NULL | Correspondance Number IBG |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
| 5 | CIP_CODE | Character(13) | VARCHAR2(13) NOT NULL | CIP code |
| 6 | SSR_FORM_STUDY_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Form of Study Higher Education
A=Auditor D=Participant E=Extraneus S=Student T=Coop/Dual |
| 7 | SAD_CFI_LOAD_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI Academic Load Netherlands
1=Full-time 2=Part-time 3=Coop/Dual |
| 8 | SAD_CFI_LEVEL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI Academic Level Netherlands
1=1st Phase 2=2nd Phase I=Initial Phase O=Old Education P=Propadeuse Phase V=Continued Phase |
| 9 | START_MONTH | Number(2,0) | SMALLINT NOT NULL | Start Date (Month) |
| 10 | END_DT_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 11 | SAD_CFI_FUND_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI Funding Code
J=Yes N=No T=Too Late |
| 12 | SAD_CFI_CD_END_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI Code End Enrollment Netherlands
0=No Specific reason 1=After end Exams 2=End Program 3=After End Prop 4=After Graduation 2nd Phase 5=Illness or Family Circumstance 6=After Start Exam 7=End after admittance 8=Death |
| 13 | MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 14 | SAD_CFI_EXM_CD_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI Examination Code Netherlands
1=Certificate Obtained 2=Discontinued Progra, 3=Certificate Obtained Later 4=Later identified Discontinued |
| 15 | SAD_CFI_STAT_NLD | Character(2) | VARCHAR2(2) NOT NULL | CFI Enrollment Funding Status Netherlands |
| 16 | SAD_CFI_STT_EXAM | Character(1) | VARCHAR2(1) NOT NULL |
Status of CFI Certificate information
1=1 Diploma 2=2 Diplomas 3=3 Diplomas 4=4 Diplomas 5=5 Diplomas 6=6 Diplomas 7=7 Diplomas 8=8 Diplomas 9=9 Diplomas E=E: Stdnt Counted last Year L=e : Stdnt fund Last Term |
| 17 | SAD_CFI_KUO_NLD | Character(1) | VARCHAR2(1) NOT NULL | KUO status for CFI Netherlands |
| 18 | SAD_CFI_DISC_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Status Discontinuation for CFI Netherlands
1=Enrollment is Discontinued 2=Nbr Diplomas Disc 2 3=Nbr Diplomas Disc 3 4=Nbr Diplomas Disc 4 5=Nbr Diplomas Disc 5 6=Nbr Diplomas Disc 6 7=Nbr Diplomas Disc 7 8=Nbr Diplomas Disc 8 9=Nbr Diplomas Disc 9 |
| 19 | SSR_CORRSPN_H_NLD | Character(12) | VARCHAR2(12) NOT NULL | History Correspondance Number |
| 20 | DATE_TO_ALIAS | Character(10) | VARCHAR2(10) NOT NULL | Date-To |
| 21 | SAD_CFI_FND_ST_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Funding Status for CFI Load
A=Fund Deconstruct N=Not Funded O=Funding Construct S=Funding Stable |
| 22 | CATALOG_NBR_TO | Number(4,0) | SMALLINT NOT NULL | Catalog Nbr To |
| 23 | SAD_CFI_EDU_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Education Type for CFI upload
K=Arts Education L=Teachers Education |
| 24 | SAD_CFI_SCH_TP_NLD | Character(4) | VARCHAR2(4) NOT NULL | cfi upload field for school type registration |
| 25 | PROG_NORM_COMPLTN | Number(3,0) | SMALLINT NOT NULL | IPEDS Normal Completion (yrs) |
| 26 | SCHOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | School Code |
| 27 | DATE_FROM_ALIAS | Character(10) | VARCHAR2(10) NOT NULL | Date-From |
| 28 | YEARS_OF_EDUCATN | Number(2,0) | SMALLINT NOT NULL | Years Of Education |
| 29 | YEAR | Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 30 | SAD_CFI_FUND_Y_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI load field for registration of funded last year
J=Funded Last Year N=Not Funded Last Year |
| 31 | SAD_CFI_EN_KUO_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI upload field for Enrollment for KUO
J=Previously Enrolled as KUO N=Not previously Enrolled as Kuo |
| 32 | YEAR_FROM | Number(4,0) | SMALLINT NOT NULL | Year From |
| 33 | YEAR_TO | Number(4,0) | SMALLINT NOT NULL | Year To |
| 34 | SAD_CFI_OW_FND_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI field for upload of OW enrollment indication
J=Enrollment relevant for OW N=Enrollment not relevant for OW |
| 35 | SAD_CFI_DIPL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI upload field for indication Diploma valid for Funding
J=Diploma is valid for OW N=Diploma not valid for OW |
| 36 | SAD_CFI_1_ENRL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI upload field, 1st enrollment at institution
J=First Enrollment Institution N=Not first enrollment inst. |
| 37 | SAD_CFI_COMP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI upload, graduated not discontinued student
J=Valid for Funding N=Not Valid for Funding |
| 38 | SAD_CFI_COMP_D_NLD | Character(1) | VARCHAR2(1) NOT NULL |
cfi upload field for indication Enrollment as graduated student
J=Enrollment Graduated early N=No Enrollment Grad Early |
| 39 | SAD_CFI_WADM_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI upload field for Disconinued Enrollments
J=Enrollment Wihdrawal N=Not Enrollment Withdrawal |
| 40 | SAD_CFI_EN_FND_NLD | Character(1) | VARCHAR2(1) NOT NULL |
CFI upload field for Funded Enrollments
J=Enrollment is Funded N=Enrollment is not funded |
| 41 | SAD_CYI_YR_RE_NLD | Character(5) | VARCHAR2(5) NOT NULL | cfi upload field, Number of years re-enttry |
| 42 | SAD_CFI_YR_FND_NLD | Character(5) | VARCHAR2(5) NOT NULL | CFI upload Field, Number of years funded |