SAD_BR_300_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 BATCH_SERIAL_NUM Number(5,0) INTEGER NOT NULL Last Sequence Nbr
4 SAD_BR_REC_TYP_NLD Character(3) VARCHAR2(3) NOT NULL Record Type

Default Value: 300

5 SAD_BR_RTP_SEQ_NLD Number(3,0) SMALLINT NOT NULL BRON Recordtype Sequence number
6 SAD_BR_EDU_SEC_NLD Character(2) VARCHAR2(2) NOT NULL Educational Sector
BO=Professional Education
ED=Education
VA=VAVO
7 CREATION_DT Date(10) DATE NOT NULL Creation Date
8 SAD_BR_LOC_NLD Character(2) VARCHAR2(2) NOT NULL Location BO
9 SAD_BR_INT_ORG_NLD Character(3) VARCHAR2(3) NOT NULL Internal Organization Number
10 SAD_BR_TYP_FILE Character(1) VARCHAR2(1) NOT NULL Type Of File
11 SAD_BR_VER_DOC_NLD Character(3) VARCHAR2(3) NOT NULL Version Requirement Document
12 SAD_BR_NAME_SA_NLD Character(80) VARCHAR2(80) NOT NULL Name Of SA System
13 SAD_BR_VER_SA_NLD Character(10) VARCHAR2(10) NOT NULL Version Of SA System
14 SAD_BR_TOT_305_REC Number(6,0) INTEGER NOT NULL Total Number Of 305 Records
15 SAD_BR_TOT_REC_NLD Number(6,0) INTEGER NOT NULL Total Nr. of records
16 SAD_BR_RES_SND_NLD Character(40) VARCHAR2(40) NOT NULL Responsible For Sending
17 SAD_BR_LST_SND_NLD Character(1) VARCHAR2(1) NOT NULL Last Send
18 SAD_BR_REC_STA_NLD Character(1) VARCHAR2(1) NOT NULL Record Status
A=Rejected
C=Created
G=Approved
V=Sent
19 SAD_BR_FI_SENT_NLD Date(10) DATE Date file send
20 BATCH_SERIAL_CHAR Character(5) VARCHAR2(5) NOT NULL Batch Serial Number String
21 SAD_BR_TOT305C_REC Character(6) VARCHAR2(6) NOT NULL Total Number Of 305 Records
22 SAD_BR_TOTRECC_NLD Character(6) VARCHAR2(6) NOT NULL Total Nr. of records