# |
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
|