SSR_BR_RSLT_DEL(SQL Table) |
Index Back |
---|---|
BRON HO Msg Stage TableBRON HO Delivery of Achieved Degree Msg Stage Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Direction
I=Inbound O=Outbound |
|
2 | DateTime(26) | TIMESTAMP | Transaction DateTime | |
3 | Number(3,0) | SMALLINT NOT NULL | Sequence Number | |
4 | Character(50) | VARCHAR2(50) NOT NULL | Index ID | |
5 | Character(12) | VARCHAR2(12) NOT NULL | Student Number | |
6 | SAD_SL_SOFI_NBR | Character(9) | VARCHAR2(9) NOT NULL | Social Fiscal Number |
7 | SAD_SL_O_NBR | Character(9) | VARCHAR2(9) NOT NULL | Onumber |
8 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
9 | SCC_SUBBRINCD_NLD | Character(2) | VARCHAR2(2) NOT NULL | Sub Institute |
10 | Character(20) | VARCHAR2(20) NOT NULL | BRON Result Seq Nbr | |
11 | SAD_SL_PROG_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code |
12 | SSR_BR_AC_LDAP_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Approved Academic Load
DT=Part-Time DU=Dual VT=Full-Time |
13 | SSR_ACAD_LEVEL_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Academ. Level Higher Education
A=Associate Degree B=Bachelor D=Propaedeutic Bachelor H=Main I=Initial Phase K=Candidate L=University teacher education M=Master P=Propaedeutic Phase Q=Post-Initial T=Interim Doctoral Exam V=Continuation Phase W=Continuing study |
14 | SAD_BR_DIPL_DT_NLD | Date(10) | DATE | Diploma Completed Date |
15 | SSR_BR_FSTDEGR_NLD | Character(1) | VARCHAR2(1) NOT NULL | First degree |