AV_BIO_CUST_TYP

(SQL Table)
 Index Back

BIO Custom Report Type

This entity stores the information forr the custom report type for the particular operator ID.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 CUSTOM_RPT_TYPE Character(25) VARCHAR2(25) NOT NULL Report Name
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