SAD_SL_SEL_PROG(SQL Table) | 
Index Back | 
|---|---|
Selection & Placement Programs | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(13) | VARCHAR2(13) NOT NULL | 
CIP code
 Prompt Table: CIP_CODE_TBL  | 
|
| 2 | Character(4) | VARCHAR2(4) NOT NULL | 
BRINcode
 Prompt Table: SCC_BRINCD_NLD  | 
|
| 3 | Character(1) | VARCHAR2(1) NOT NULL | 
Academic Load
 F=Enrolled Full-Time H=Enrolled Half-Time L=Less than Half-Time N=No Unit Load P=Enrolled Part-Time T=Three Quarter Time  | 
|
| 4 | Character(4) | VARCHAR2(4) NOT NULL | 
Academic Year
 Prompt Table: ACAD_YEAR_MC_VW  | 
|
| 5 | SAD_SL_PROG_LD_STA | Character(1) | VARCHAR2(1) NOT NULL | 
Studielink Program Load Status
 N=New P=In Progress S=Sent  | 
| 6 | SAD_SL_PROC_SELECT | Character(1) | VARCHAR2(1) NOT NULL | 
Select to Process
 N=No Y=Yes  |