CS_DOC_UFLD_HST

(SQL Table)
Index Back

History Rec for User Def Flds

1/7/2008 cel History record for user def fields per document

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 CS_DOC_UFLD_VER Number(3,0) SMALLINT NOT NULL User Defined Field Version
3 CS_CHAR_USER1 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 1
4 CS_CHAR_USER2 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 2
5 CS_CHAR_USER3 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 3
6 CS_CHAR_USER4 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 4
7 CS_CHAR_USER5 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 5
8 CS_CHAR_USER6 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 6
9 CS_CHAR_USER7 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 7
10 CS_CHAR_USER8 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 8
11 CS_CHAR_USER9 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 9
12 CS_CHAR_USER10 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 10
13 CS_CHAR_USER11 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 11
14 CS_CHAR_USER12 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 12
15 CS_CHAR_USER13 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 13
16 CS_CHAR_USER14 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 14
17 CS_CHAR_USER15 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 15
18 CS_CHAR_USER16 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 16
19 CS_CHAR_USER17 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 17
20 CS_CHAR_USER18 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 18
21 CS_CHAR_USER19 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 19
22 CS_CHAR_USER20 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 20
23 CS_CHAR_USER21 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 21
24 CS_CHAR_USER22 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 22
25 CS_CHAR_USER23 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 23
26 CS_CHAR_USER24 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 24
27 CS_CHAR_USER25 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 25
28 CS_CHAR_USER26 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 26
29 CS_CHAR_USER27 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 27
30 CS_CHAR_USER28 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 28
31 CS_CHAR_USER29 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 29
32 CS_CHAR_USER30 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 30
33 CS_CHAR_USER31 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 31
34 CS_CHAR_USER32 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 32
35 CS_CHAR_USER33 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 33
36 CS_CHAR_USER34 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 34
37 CS_CHAR_USER35 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 35
38 CS_CHAR_USER36 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 36
39 CS_CHAR_USER37 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 37
40 CS_CHAR_USER38 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 38
41 CS_DATE_USER1 Date(10) DATE Date User Field 1
42 CS_DATE_USER2 Date(10) DATE Date User Field 2
43 CS_DATE_USER3 Date(10) DATE Date User Field 3
44 CS_DATE_USER4 Date(10) DATE Date User Field 4
45 CS_DATE_USER5 Date(10) DATE Date User Field 5
46 CS_DATE_USER6 Date(10) DATE Date User Field 6
47 CS_DATE_USER7 Date(10) DATE Date User Field 7
48 CS_DATE_USER8 Date(10) DATE Date User Field 8
49 CS_DATE_USER9 Date(10) DATE Date User Field 9
50 CS_DATE_USER10 Date(10) DATE Date User Field 10
51 CS_DATE_USER11 Date(10) DATE Date User Field 11
52 CS_DATE_USER12 Date(10) DATE Date User Field 12
53 CS_DATE_USER13 Date(10) DATE Date User Field 13
54 CS_DATE_USER14 Date(10) DATE Date User Field 14
55 CS_DATE_USER15 Date(10) DATE Date User Field 15
56 CS_DEC_USER1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 1 (23.3)
57 CS_DEC_USER2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 2 (23.3)
58 CS_DEC_USER3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 3 (23.3)
59 CS_DEC_USER4 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 4 (11.4)
60 CS_DEC_USER5 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field5 (11.4)
61 CS_DEC_USER6 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 6 (23.3)
62 CS_DEC_USER7 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 7 (23.3)
63 CS_DEC_USER8 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 8 (23.3)
64 CS_DEC_USER9 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 9 (23.3)
65 CS_DEC_USER10 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 10 (23.3)
66 CS_DEC_USER11 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 11 (23.3)
67 CS_DEC_USER12 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 12 (11.4)
68 CS_DEC_USER13 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 13 (11.4)
69 CS_DEC_USER14 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 14 (11.4)
70 CS_DEC_USER15 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 15 (11.4)
71 CS_INT_USER1 Number(8,0) INTEGER NOT NULL Integer User Field 1
72 CS_INT_USER2 Number(8,0) INTEGER NOT NULL Integer User Field 2
73 CS_INT_USER3 Number(8,0) INTEGER NOT NULL Integer User Field 3
74 CS_INT_USER4 Number(8,0) INTEGER NOT NULL Integer User Field 4
75 CS_INT_USER5 Number(8,0) INTEGER NOT NULL Integer User Field 5
76 CS_INT_USER6 Number(8,0) INTEGER NOT NULL Integer User Field 6
77 CS_INT_USER7 Number(8,0) INTEGER NOT NULL Integer User Field 7
78 CS_INT_USER8 Number(8,0) INTEGER NOT NULL Integer User Field 8
79 CS_INT_USER9 Number(8,0) INTEGER NOT NULL Integer User Field 9
80 CS_INT_USER10 Number(8,0) INTEGER NOT NULL Integer User Field 10
81 CS_INT_USER11 Number(8,0) INTEGER NOT NULL Integer User Field 11
82 CS_INT_USER12 Number(8,0) INTEGER NOT NULL Integer User Field 12
83 CS_INT_USER13 Number(8,0) INTEGER NOT NULL Integer User Field 13
84 CS_INT_USER14 Number(8,0) INTEGER NOT NULL Integer User Field 14
85 CS_INT_USER15 Number(8,0) INTEGER NOT NULL Integer User Field 15
86 CS_INT_USER16 Number(8,0) INTEGER NOT NULL Integer User Field 16
87 CS_INT_USER17 Number(8,0) INTEGER NOT NULL Integer User Field 17
88 CS_INT_USER18 Number(8,0) INTEGER NOT NULL Integer User Field 18
89 CS_INT_USER19 Number(8,0) INTEGER NOT NULL Integer User Field 19
90 CS_INT_USER20 Number(8,0) INTEGER NOT NULL Integer User Field 20
91 CS_INT_USER21 Number(8,0) INTEGER NOT NULL Integer User Field 21
92 CS_INT_USER22 Number(8,0) INTEGER NOT NULL Integer User Field 22
93 CS_INT_USER23 Number(8,0) INTEGER NOT NULL Integer User Field 23
94 CS_INT_USER24 Number(8,0) INTEGER NOT NULL Integer User Field 24