SAD_BR_GBA_AET(SQL Table) |
Index Back |
|---|---|
BRON GBA State RecordState Record used for update of GBA data received from BRON |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTN_SCRTY |
| 5 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table: SCC_BRINCD_NLD |
| 6 | SAD_BR_EDU_SEC_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Educational Sector
BO=Professional Education ED=Education VA=VAVO |
| 7 | SAD_BR_CRE_FIL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON Create file
Y/N Table Edit |
| 8 | SAD_BR_SND_FIL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON Send file
Y/N Table Edit |
| 9 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
| 10 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 11 | SAD_BR_LST_SND_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Last Send
Y/N Table Edit |
| 12 | SAD_BR_RESPONS_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Responsible
A=Accountant C=CFI I=Institution |
| 13 | SAD_BR_BRON_BN_NLD | Number(3,0) | SMALLINT NOT NULL |
BRON Batchnumber
Prompt Table: SAD_BR_RE400_VW |
| 14 | SAD_BR_UPD_ALL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No field fr runcontrol
Y/N Table Edit |
| 15 | SAD_BR_DEL_NA_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Delete Not Accepted data
Y/N Table Edit |
| 16 | SAD_BR_GBA_ACT_NLD | Character(1) | VARCHAR2(1) NOT NULL |
GBA action
F=Fill GBA interim table U=Update GBA data in Peoplesoft |
| 17 | SAD_BR_NTGBA_NLD | Character(3) | VARCHAR2(3) NOT NULL | Name Type GBA |
| 18 | SAD_BR_ATGBA_NLD | Character(4) | VARCHAR2(4) NOT NULL | Address Type GBA |
| 19 | BATCH_SERIAL_NUM | Number(5,0) | INTEGER NOT NULL | Last Sequence Nbr |
| 20 | SAD_BR_SEQ_NBR_NLD | Number(6,0) | INTEGER NOT NULL | Sequence Number |
| 21 | CREATION_DT | Date(10) | DATE | Creation Date |
| 22 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 23 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 24 | NAME_ROYAL_PREFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Royal Prefix |
| 25 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 26 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 27 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 28 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 29 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 30 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 31 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 32 | SAD_BR_SEX_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON Sex
M=Male O=Unknown V=Female |
| 33 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 34 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 35 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 36 | SAD_BR_NAT_ID_NLD | Character(20) | VARCHAR2(20) NOT NULL | Educational Number |
| 37 | SAD_GBA_B_YR_NLD | Character(4) | VARCHAR2(4) NOT NULL | GBA Year of Birth |
| 38 | SAD_GBA_B_MN_NLD | Character(2) | VARCHAR2(2) NOT NULL | GBA Month of Birth |
| 39 | LAST_NAME_CD | Character(30) | VARCHAR2(30) NOT NULL | Field Last_Name_CD stores the last name for the name field in the community directory. |
| 40 | SAD_GBA_PRFX_NLD | Character(15) | VARCHAR2(15) NOT NULL | Name Prefix GBA |
| 41 | SAD_BR_FST_NMS_NLD | Character(200) | VARCHAR2(200) NOT NULL | Firstnames |
| 42 | ADDRESS3_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 3 Other |
| 43 | NUM1_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 1 Other |
| 44 | NUM2_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 2 Other |
| 45 | CITY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | City Other |
| 46 | SAD_BR_PSTAL_C_NLD | Character(12) | VARCHAR2(12) NOT NULL | Modified Postal |
| 47 | SAD_BR_SEX_C_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Modified Sex
M=Male O=Unknown V=Female |
| 48 | SAD_BR_BIRTH_C_NLD | Date(10) | DATE | Modified Birthdate |
| 49 | SAD_GBA_BYRC_NLD | Character(4) | VARCHAR2(4) NOT NULL | Changed Birth Yr GBA |
| 50 | SAD_GBA_BMNC_NLD | Character(2) | VARCHAR2(2) NOT NULL | Changed Birth Month GBA |
| 51 | SAD_BR_NATID_C_NLD | Character(20) | VARCHAR2(20) NOT NULL | Modified SOFI Number |
| 52 | SAD_BR_OWNR_NLD | Character(20) | VARCHAR2(20) NOT NULL | Educational Number BRON |