INSTITUTIONSCC_BRINCD_NLDSAD_BR_LOC_NLDSAD_BR_EDU_SEC_NLDBO=Professional Education
ED=Education
VA=VAVO
SAD_BR_BRON_BN_NLDSAD_BR_REC_TYP_NLDDefault Value: 400
SAD_BR_400_NLD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
| 3 | SAD_BR_LOC_NLD |
Character(2) | VARCHAR2(2) NOT NULL | Location BO |
| 4 | SAD_BR_EDU_SEC_NLD |
Character(2) | VARCHAR2(2) NOT NULL |
Educational Sector
BO=Professional Education ED=Education VA=VAVO |
| 5 | SAD_BR_BRON_BN_NLD |
Number(3,0) | SMALLINT NOT NULL | BRON Batchnumber |
| 6 | SAD_BR_REC_TYP_NLD |
Character(3) | VARCHAR2(3) NOT NULL |
Record Type
Default Value: 400 |
| 7 | SAD_BR_TYP_FILE | Character(1) | VARCHAR2(1) NOT NULL | Type Of File |
| 8 | SAD_BR_DT_REP_NLD | Date(10) | DATE | BRON Report date |
| 9 | SAD_BR_TOT_SND_NLD | Number(2,0) | SMALLINT NOT NULL | Total Nbr Of Sent Batch Files |