GPSC_ELM_BR

(SQL View)
 Index Back

Bracket Definition

Bracket Definition

SELECT PIN_NUM , EFFDT , EFF_STATUS , PIN_RND_NUM , INTERPOLATE_METHOD , LOW_HIGH_OPTION , PROCESS_OPTION , USE_FIRST_ROW , USE_LAST_ROW , KEY_COUNT , VAL_RETURN_COUNT , ENTRY_TYPE_KEY1 , ENTRY_TYPE_KEY2 , ENTRY_TYPE_KEY3 , ENTRY_TYPE_KEY4 , ENTRY_TYPE_KEY5 , PIN_KEY1_NUM , PIN_KEY2_NUM , PIN_KEY3_NUM , PIN_KEY4_NUM , PIN_KEY5_NUM , FLD_FMT_KEY1 , FLD_FMT_KEY2 , FLD_FMT_KEY3 , FLD_FMT_KEY4 , FLD_FMT_KEY5 , ENTRY_TYPE_VAL1 , ENTRY_TYPE_VAL2 , ENTRY_TYPE_VAL3 , ENTRY_TYPE_VAL4 , ENTRY_TYPE_VAL5 , ENTRY_TYPE_VAL6 , ENTRY_TYPE_VAL7 , ENTRY_TYPE_VAL8 , PIN_VAL1_NUM , PIN_VAL2_NUM , PIN_VAL3_NUM , PIN_VAL4_NUM , PIN_VAL5_NUM , PIN_VAL6_NUM , PIN_VAL7_NUM , PIN_VAL8_NUM , FLD_FMT_VAL1 , FLD_FMT_VAL2 , FLD_FMT_VAL3 , FLD_FMT_VAL4 , FLD_FMT_VAL5 , FLD_FMT_VAL6 , FLD_FMT_VAL7 , FLD_FMT_VAL8 , GP_VERSION FROM PS_GP_BRACKET WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , EFF_STATUS , PIN_RND_NUM , INTERPOLATE_METHOD , LOW_HIGH_OPTION , PROCESS_OPTION , USE_FIRST_ROW , USE_LAST_ROW , KEY_COUNT , VAL_RETURN_COUNT , ENTRY_TYPE_KEY1 , ENTRY_TYPE_KEY2 , ENTRY_TYPE_KEY3 , ENTRY_TYPE_KEY4 , ENTRY_TYPE_KEY5 , PIN_KEY1_NUM , PIN_KEY2_NUM , PIN_KEY3_NUM , PIN_KEY4_NUM , PIN_KEY5_NUM , FLD_FMT_KEY1 , FLD_FMT_KEY2 , FLD_FMT_KEY3 , FLD_FMT_KEY4 , FLD_FMT_KEY5 , ENTRY_TYPE_VAL1 , ENTRY_TYPE_VAL2 , ENTRY_TYPE_VAL3 , ENTRY_TYPE_VAL4 , ENTRY_TYPE_VAL5 , ENTRY_TYPE_VAL6 , ENTRY_TYPE_VAL7 , ENTRY_TYPE_VAL8 , PIN_VAL1_NUM , PIN_VAL2_NUM , PIN_VAL3_NUM , PIN_VAL4_NUM , PIN_VAL5_NUM , PIN_VAL6_NUM , PIN_VAL7_NUM , PIN_VAL8_NUM , FLD_FMT_VAL1 , FLD_FMT_VAL2 , FLD_FMT_VAL3 , FLD_FMT_VAL4 , FLD_FMT_VAL5 , FLD_FMT_VAL6 , FLD_FMT_VAL7 , FLD_FMT_VAL8 , GP_VERSION FROM PS_GPSC_RM_BRACKET WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 EFFDT Date(10) DATE NOT NULL Effective Date
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 PIN_RND_NUM Number(8,0) INTEGER NOT NULL Rounding Element Number

Prompt Table: GP_PIN_RR0_VW

5 INTERPOLATE_METHOD Character(1) VARCHAR2(1) NOT NULL Bracket Interpolation Method
H=Use Next Higher
I=Linear
L=Use Next Lower
N=Use Nearest
6 LOW_HIGH_OPTION Character(1) VARCHAR2(1) NOT NULL Low/High Bracket Interpolation option
N=No
Y=Yes
7 PROCESS_OPTION Character(1) VARCHAR2(1) NOT NULL Bracket Error processing option
E=Generate Error
P=Continue Process
8 USE_FIRST_ROW Character(1) VARCHAR2(1) NOT NULL Use/Don't Use the first row on Interpolation Option
N=No
Y=Yes
9 USE_LAST_ROW Character(1) VARCHAR2(1) NOT NULL Use/Don't Use the first row on Interpolation Option
N=No
Y=Yes
10 KEY_COUNT Number(3,0) SMALLINT NOT NULL Number of Bracket Keys
11 VAL_RETURN_COUNT Number(3,0) SMALLINT NOT NULL Number of Return Columns
12 ENTRY_TYPE_KEY1 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key

Prompt Table: GP_ENT_BRKTK_VW

13 ENTRY_TYPE_KEY2 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key

Prompt Table: GP_ENT_BRKTK_VW

14 ENTRY_TYPE_KEY3 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key

Prompt Table: GP_ENT_BRKTK_VW

15 ENTRY_TYPE_KEY4 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key

Prompt Table: GP_ENT_BRKTK_VW

16 ENTRY_TYPE_KEY5 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Key

Prompt Table: GP_ENT_BRKTK_VW

17 PIN_KEY1_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number

Prompt Table: %GP_EDIT_FLD1

18 PIN_KEY2_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number

Prompt Table: %GP_EDIT_FLD2

19 PIN_KEY3_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number

Prompt Table: %GP_EDIT_FLD3

20 PIN_KEY4_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number

Prompt Table: %GP_EDIT_FLD4

21 PIN_KEY5_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number

Prompt Table: %GP_EDIT_FLD5

22 FLD_FMT_KEY1 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
23 FLD_FMT_KEY2 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
24 FLD_FMT_KEY3 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
25 FLD_FMT_KEY4 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
26 FLD_FMT_KEY5 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Key
27 ENTRY_TYPE_VAL1 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

Prompt Table: GP_ENTRY_TYPE

28 ENTRY_TYPE_VAL2 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

Prompt Table: GP_ENT_BRKTP_VW

29 ENTRY_TYPE_VAL3 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

Prompt Table: GP_ENT_BRKTP_VW

30 ENTRY_TYPE_VAL4 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

Prompt Table: GP_ENT_BRKTP_VW

31 ENTRY_TYPE_VAL5 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

Prompt Table: GP_ENT_BRKTP_VW

32 ENTRY_TYPE_VAL6 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

Prompt Table: GP_ENT_BRKTP_VW

33 ENTRY_TYPE_VAL7 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

Prompt Table: GP_ENT_BRKTP_VW

34 ENTRY_TYPE_VAL8 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

Prompt Table: GP_ENT_BRKTP_VW

35 PIN_VAL1_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
36 PIN_VAL2_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

Prompt Table: %GP_EDIT_FLD7

37 PIN_VAL3_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

Prompt Table: %GP_EDIT_FLD8

38 PIN_VAL4_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

Prompt Table: %GP_EDIT_FLD9

39 PIN_VAL5_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

Prompt Table: %GP_EDIT_FLD10

40 PIN_VAL6_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

Prompt Table: %GP_EDIT_FLD11

41 PIN_VAL7_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

Prompt Table: %GP_EDIT_FLD12

42 PIN_VAL8_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

Prompt Table: %GP_EDIT_FLD13

43 FLD_FMT_VAL1 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
44 FLD_FMT_VAL2 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
45 FLD_FMT_VAL3 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
46 FLD_FMT_VAL4 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
47 FLD_FMT_VAL5 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
48 FLD_FMT_VAL6 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
49 FLD_FMT_VAL7 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
50 FLD_FMT_VAL8 Character(1) VARCHAR2(1) NOT NULL Field Format for Bracket Value
51 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.