GP_PKG_BR1_AD

(SQL Table)
 Index Back

Bracket Definition

Bracket Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
3 EFFDT Date(10) DATE Effective Date
4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 PIN_RND_NUM Number(8,0) INTEGER NOT NULL Rounding Element Number
6 INTERPOLATE_METHOD Character(1) VARCHAR2(1) NOT NULL Bracket Interpolation Method
H=Use Next Higher
I=Linear
L=Use Next Lower
N=Use Nearest
7 LOW_HIGH_OPTION Character(1) VARCHAR2(1) NOT NULL Low/High Bracket Interpolation option
N=No
Y=Yes
8 PROCESS_OPTION Character(1) VARCHAR2(1) NOT NULL Bracket Error processing option
E=Generate Error
P=Continue Process
9 USE_FIRST_ROW Character(1) VARCHAR2(1) NOT NULL Use/Don't Use the first row on Interpolation Option
N=No
Y=Yes
10 USE_LAST_ROW Character(1) VARCHAR2(1) NOT NULL Use/Don't Use the first row on Interpolation Option
N=No
Y=Yes
11 KEY_COUNT Number(3,0) SMALLINT NOT NULL Number of Bracket Keys
12 VAL_RETURN_COUNT Number(3,0) SMALLINT NOT NULL Number of Return Columns
13 ENTRY_TYPE_KEY1 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key
14 ENTRY_TYPE_KEY2 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key
15 ENTRY_TYPE_KEY3 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key
16 ENTRY_TYPE_KEY4 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key
17 ENTRY_TYPE_KEY5 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key
18 PIN_KEY1_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number
19 PIN_KEY2_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number
20 PIN_KEY3_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number
21 PIN_KEY4_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number
22 PIN_KEY5_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number
23 FLD_FMT_KEY1 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
24 FLD_FMT_KEY2 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
25 FLD_FMT_KEY3 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
26 FLD_FMT_KEY4 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
27 FLD_FMT_KEY5 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
28 ENTRY_TYPE_VAL1 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
29 ENTRY_TYPE_VAL2 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
30 ENTRY_TYPE_VAL3 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
31 ENTRY_TYPE_VAL4 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
32 ENTRY_TYPE_VAL5 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
33 ENTRY_TYPE_VAL6 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
34 ENTRY_TYPE_VAL7 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
35 ENTRY_TYPE_VAL8 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
36 PIN_VAL1_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
37 PIN_VAL2_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
38 PIN_VAL3_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
39 PIN_VAL4_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
40 PIN_VAL5_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
41 PIN_VAL6_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
42 PIN_VAL7_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
43 PIN_VAL8_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
44 FLD_FMT_VAL1 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
45 FLD_FMT_VAL2 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
46 FLD_FMT_VAL3 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
47 FLD_FMT_VAL4 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
48 FLD_FMT_VAL5 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
49 FLD_FMT_VAL6 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
50 FLD_FMT_VAL7 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
51 FLD_FMT_VAL8 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
52 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.