# |
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 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
3 |
SEQUENCENO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
|
4 |
GPIT_NUM_BOX1 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box1
|
5 |
GPIT_NUM_BOX2 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box2
|
6 |
GPIT_NUM_BOX3 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box3
|
7 |
GPIT_NUM_BOX4 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box4
|
8 |
GPIT_NUM_BOX5 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box5
|
9 |
GPIT_NUM_BOX06 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
10 |
GPIT_NUM_BOX7 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box7
|
11 |
GPIT_NUM_BOX8 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box8
|
12 |
GPIT_NUM_BOX9 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box9
|
13 |
GPIT_NUM_BOX10 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box10
|
14 |
GPIT_NUM_BOX11 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box11
|
15 |
GPIT_NUM_BOX12 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box12
|
16 |
GPIT_NUM_BOX13 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box13
|
17 |
GPIT_NUM_BOX14 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box14
|
18 |
GPIT_NUM_BOX15 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box15
|
19 |
GPIT_NUM_BOX16 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 16
|
20 |
GPIT_NUM_BOX17 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 17
|
21 |
GPIT_NUM_BOX18 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 18
|
22 |
GPIT_NUM_BOX19 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box19
|
23 |
GPIT_NUM_BOX20 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box20
|
24 |
GPIT_NUM_BOX21 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box21
|
25 |
GPIT_NUM_BOX22 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 22
|
26 |
GPIT_NUM_BOX23 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box23
|
27 |
GPIT_NUM_BOX24 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 24
|
28 |
GPIT_NUM_BOX25 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box25
|
29 |
GPIT_NUM_BOX26 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box26
|
30 |
GPIT_NUM_BOX27 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box27
|
31 |
GPIT_NUM_BOX28 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 28
|
32 |
GPIT_NUM_BOX29 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box29
|
33 |
GPIT_NUM_BOX30 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
34 |
GPIT_NUM_BOX31 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
35 |
GPIT_NUM_BOX32 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
36 |
GPIT_NUM_BOX33 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 33
|
37 |
GPIT_NUM_BOX34 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 34
|
38 |
GPIT_NUM_BOX35 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box35
|
39 |
GPIT_NUM_BOX36 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 36
|
40 |
GPIT_NUM_BOX37 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
41 |
GPIT_NUM_BOX38 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
42 |
GPIT_NUM_BOX39 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
43 |
GPIT_NUM_BOX40 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
44 |
GPIT_NUM_BOX41 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
45 |
GPIT_NUM_BOX42 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
46 |
GPIT_NUM_BOX43 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
47 |
GPIT_NUM_BOX44 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
48 |
GPIT_NUM_BOX45 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
49 |
GPIT_NUM_BOX46 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
50 |
GPIT_NUM_BOX47 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box 47
|
51 |
GPIT_NUM_BOX48 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box48
|
52 |
GPIT_NUM_BOX49 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box49
|
53 |
GPIT_NUM_BOX50 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box50
|
54 |
GPIT_NUM_BOX51 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
55 |
GPIT_NUM_BOX52 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
56 |
GPIT_NUM_BOX53 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
57 |
GPIT_NUM_BOX54 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
58 |
GPIT_NUM_BOX55 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
59 |
GPIT_NUM_BOX56 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
60 |
GPIT_NUM_BOX57 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box57
|
61 |
GPIT_NUM_BOX58 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box58
|
62 |
GPIT_NUM_BOX59 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box59
|
63 |
GPIT_NUM_BOX60 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box60
|
64 |
GPIT_NUM_BOX61 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box61
|
65 |
GPIT_NUM_BOX62 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
66 |
GPIT_NUM_BOX63 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
67 |
GPIT_NUM_BOX64 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
68 |
GPIT_NUM_BOX65 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
69 |
GPIT_NUM_BOX66 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
70 |
GPIT_NUM_BOX67 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
71 |
GPIT_NUM_BOX68 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
72 |
GPIT_NUM_BOX69 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
73 |
GPIT_NUM_BOX70 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
74 |
GPIT_NUM_BOX71 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
75 |
GPIT_NUM_BOX72 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
76 |
GPIT_NUM_BOX73 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
77 |
GPIT_NUM_BOX74 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
78 |
GPIT_NUM_BOX75 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric Box
|
79 |
GPIT_TMP_CHAR01_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for Electronic DM10 Report.
|
80 |
GPIT_TMP_CHAR01_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for Electronic DM10 Report.
|
81 |
GPIT_TMP_CHAR01_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for Electronic DM10 Report.
|
82 |
GPIT_TMP_CHAR01_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for Electronic DM10 Report.
|