MASS_VIEW_WRK

(SQL Table)
Index Back

Item Ctlg Maint Template Work

Item Catalog Maintenance Template Work Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 DESCRLONG Long Character CLOB Long Description
4 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
5 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
6 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
7 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
8 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
9 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
10 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
11 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
12 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
13 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
14 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
15 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
16 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
17 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
18 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
19 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
20 ITEM_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
21 ITEM_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
22 ITEM_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
23 ITEM_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
24 ITEM_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
25 ITEM_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
26 ITEM_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
27 ITEM_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0