PROJECT_SD

(SQL Table)
Index Back

Project Supplemental Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 SD_RECNAME Character(15) VARCHAR2(15) NOT NULL Supplementa Data Record
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 SD_DATE_1 Date(10) DATE Date Field
6 SD_DATE_2 Date(10) DATE Date Field
7 SD_DATE_3 Date(10) DATE Date Field
8 SD_DATE_4 Date(10) DATE Date Field
9 SD_DATE_5 Date(10) DATE Date Field
10 SD_TIME_1 Time(15) TIMESTAMP Time Field
11 SD_TIME_2 Time(15) TIMESTAMP Time Field
12 SD_TIME_3 Time(15) TIMESTAMP Time Field
13 SD_TIME_4 Time(15) TIMESTAMP Time Field
14 SD_TIME_5 Time(15) TIMESTAMP Time Field
15 SD_TEXT4_1 Character(4) VARCHAR2(4) NOT NULL Text
16 SD_TEXT4_2 Character(4) VARCHAR2(4) NOT NULL Text
17 SD_TEXT4_3 Character(4) VARCHAR2(4) NOT NULL Text
18 SD_TEXT4_4 Character(4) VARCHAR2(4) NOT NULL Text
19 SD_TEXT4_5 Character(4) VARCHAR2(4) NOT NULL Text
20 SD_TEXT4_6 Character(4) VARCHAR2(4) NOT NULL Text
21 SD_TEXT4_7 Character(4) VARCHAR2(4) NOT NULL Text
22 SD_TEXT4_8 Character(4) VARCHAR2(4) NOT NULL Text
23 SD_TEXT4_9 Character(4) VARCHAR2(4) NOT NULL Text
24 SD_TEXT4_10 Character(4) VARCHAR2(4) NOT NULL Text
25 SD_TEXT20_1 Character(20) VARCHAR2(20) NOT NULL Text Field
26 SD_TEXT20_2 Character(20) VARCHAR2(20) NOT NULL Text Field
27 SD_TEXT20_3 Character(20) VARCHAR2(20) NOT NULL Text Field
28 SD_TEXT20_4 Character(20) VARCHAR2(20) NOT NULL Text Field
29 SD_TEXT20_5 Character(20) VARCHAR2(20) NOT NULL Text Field
30 SD_TEXT20_6 Character(20) VARCHAR2(20) NOT NULL Text Field
31 SD_TEXT20_7 Character(20) VARCHAR2(20) NOT NULL Text Field
32 SD_TEXT20_8 Character(20) VARCHAR2(20) NOT NULL Text Field
33 SD_TEXT20_9 Character(20) VARCHAR2(20) NOT NULL Text Field
34 SD_TEXT20_10 Character(20) VARCHAR2(20) NOT NULL Text Field
35 SD_TEXT20_11 Character(20) VARCHAR2(20) NOT NULL Text Field
36 SD_TEXT20_12 Character(20) VARCHAR2(20) NOT NULL Text Field
37 SD_TEXT20_13 Character(20) VARCHAR2(20) NOT NULL Text Field
38 SD_TEXT20_14 Character(20) VARCHAR2(20) NOT NULL Text Field
39 SD_TEXT20_15 Character(20) VARCHAR2(20) NOT NULL Text Field
40 SD_TEXT50_1 Character(50) VARCHAR2(50) NOT NULL Text Field
41 SD_TEXT50_2 Character(50) VARCHAR2(50) NOT NULL Text Field
42 SD_TEXT50_3 Character(50) VARCHAR2(50) NOT NULL Text Field
43 SD_TEXT50_4 Character(50) VARCHAR2(50) NOT NULL Text Field
44 SD_TEXT50_5 Character(50) VARCHAR2(50) NOT NULL Text Field
45 SD_TEXT50_6 Character(50) VARCHAR2(50) NOT NULL Text Field
46 SD_TEXT50_7 Character(50) VARCHAR2(50) NOT NULL Text Field
47 SD_TEXT50_8 Character(50) VARCHAR2(50) NOT NULL Text Field
48 SD_TEXT50_9 Character(50) VARCHAR2(50) NOT NULL Text Field
49 SD_TEXT50_10 Character(50) VARCHAR2(50) NOT NULL Text Field
50 SD_INT_1 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
51 SD_INT_2 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
52 SD_INT_3 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
53 SD_INT_4 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
54 SD_INT_5 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
55 SD_NUM9_1 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
56 SD_NUM9_2 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
57 SD_NUM9_3 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
58 SD_NUM9_4 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
59 SD_NUM9_5 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
60 SD_NUM9_6 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
61 SD_NUM9_7 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
62 SD_NUM9_8 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
63 SD_NUM9_9 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
64 SD_NUM9_10 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
65 SD_NUM19_1 Signed Number(21,4) DECIMAL(19,4) NOT NULL Number
66 SD_NUM19_2 Signed Number(21,4) DECIMAL(19,4) NOT NULL Number
67 SD_NUM19_3 Signed Number(21,4) DECIMAL(19,4) NOT NULL Number
68 SD_NUM19_4 Signed Number(21,4) DECIMAL(19,4) NOT NULL Number
69 SD_NUM19_5 Signed Number(21,4) DECIMAL(19,4) NOT NULL Number