AV_BIOBIT_SETUP

(SQL Table)
 Index Back

BIO BIT Setup Table

This table is used to store the setup information for the standard report type.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 BIO_BIT_RPT_TYPE Character(1) VARCHAR2(1) NOT NULL Bio Bit Report Type
B=Bio Bit
C=Custom
R=Bio Brief
3 AV_FLAG_A Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

4 AV_FLAG_B Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

5 AV_FLAG_C Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

6 AV_FLAG_D Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

7 AV_FLAG_E Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

8 AV_FLAG_F Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

9 AV_FLAG_G Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

10 AV_FLAG_H Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

11 AV_FLAG_I Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

12 AV_FLAG_J Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

13 AV_FLAG_K Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

14 AV_FLAG_L Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

15 AV_FLAG_M Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

16 AV_FLAG_N Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

17 AV_FLAG_O Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

18 AV_FLAG_P Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

19 AV_FLAG_Q Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

20 AV_FLAG_R Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

21 AV_FLAG_S Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

22 AV_FLAG_T Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

23 AV_FLAG_U Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

24 AV_FLAG_V Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

25 AV_FLAG_W Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

26 AV_FLAG_X Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

27 AV_FLAG_Y Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y

28 AV_FLAG_Z Character(1) VARCHAR2(1) NOT NULL CAE Report Field

Y/N Table Edit

Default Value: Y