GPSC_ELM_BR_DTL (SQL View)	Index Back
Bracket Value Entries Bracket Value Entries

GPSC_ELM_BR_DTL

(SQL View)

Bracket Value Entries

SELECT PIN_NUM , EFFDT , DATA_KEY1 , DATA_KEY1_DT , DATA_KEY1_DEC , DATA_KEY2 , DATA_KEY2_DT , DATA_KEY2_DEC , DATA_KEY3 , DATA_KEY3_DT , DATA_KEY3_DEC , DATA_KEY4 , DATA_KEY4_DT , DATA_KEY4_DEC , DATA_KEY5 , DATA_KEY5_DT , DATA_KEY5_DEC , DATA_VAL1 , DATA_VAL1_DT , DATA_VAL1_DEC , DATA_VAL1_CURR , ENTRY_TYPE_VAL1 , PIN_VAL1_NUM , DATA_VAL2 , DATA_VAL2_DT , DATA_VAL2_DEC , DATA_VAL2_CURR , ENTRY_TYPE_VAL2 , PIN_VAL2_NUM , DATA_VAL3 , DATA_VAL3_DT , DATA_VAL3_DEC , DATA_VAL3_CURR , ENTRY_TYPE_VAL3 , PIN_VAL3_NUM , DATA_VAL4 , DATA_VAL4_DT , DATA_VAL4_DEC , DATA_VAL4_CURR , ENTRY_TYPE_VAL4 , PIN_VAL4_NUM , DATA_VAL5 , DATA_VAL5_DT , DATA_VAL5_DEC , DATA_VAL5_CURR , ENTRY_TYPE_VAL5 , PIN_VAL5_NUM , DATA_VAL6 , DATA_VAL6_DT , DATA_VAL6_DEC , DATA_VAL6_CURR , ENTRY_TYPE_VAL6 , PIN_VAL6_NUM , DATA_VAL7 , DATA_VAL7_DT , DATA_VAL7_DEC , DATA_VAL7_CURR , ENTRY_TYPE_VAL7 , PIN_VAL7_NUM , DATA_VAL8 , DATA_VAL8_DT , DATA_VAL8_DEC , DATA_VAL8_CURR , ENTRY_TYPE_VAL8 , PIN_VAL8_NUM FROM PS_GP_BRACKET_DTL WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , DATA_KEY1 , DATA_KEY1_DT , DATA_KEY1_DEC , DATA_KEY2 , DATA_KEY2_DT , DATA_KEY2_DEC , DATA_KEY3 , DATA_KEY3_DT , DATA_KEY3_DEC , DATA_KEY4 , DATA_KEY4_DT , DATA_KEY4_DEC , DATA_KEY5 , DATA_KEY5_DT , DATA_KEY5_DEC , DATA_VAL1 , DATA_VAL1_DT , DATA_VAL1_DEC , DATA_VAL1_CURR , ENTRY_TYPE_VAL1 , PIN_VAL1_NUM , DATA_VAL2 , DATA_VAL2_DT , DATA_VAL2_DEC , DATA_VAL2_CURR , ENTRY_TYPE_VAL2 , PIN_VAL2_NUM , DATA_VAL3 , DATA_VAL3_DT , DATA_VAL3_DEC , DATA_VAL3_CURR , ENTRY_TYPE_VAL3 , PIN_VAL3_NUM , DATA_VAL4 , DATA_VAL4_DT , DATA_VAL4_DEC , DATA_VAL4_CURR , ENTRY_TYPE_VAL4 , PIN_VAL4_NUM , DATA_VAL5 , DATA_VAL5_DT , DATA_VAL5_DEC , DATA_VAL5_CURR , ENTRY_TYPE_VAL5 , PIN_VAL5_NUM , DATA_VAL6 , DATA_VAL6_DT , DATA_VAL6_DEC , DATA_VAL6_CURR , ENTRY_TYPE_VAL6 , PIN_VAL6_NUM , DATA_VAL7 , DATA_VAL7_DT , DATA_VAL7_DEC , DATA_VAL7_CURR , ENTRY_TYPE_VAL7 , PIN_VAL7_NUM , DATA_VAL8 , DATA_VAL8_DT , DATA_VAL8_DEC , DATA_VAL8_CURR , ENTRY_TYPE_VAL8 , PIN_VAL8_NUM FROM PS_GPSC_RM_BR_DTL 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 DATA_KEY1 Character(18) VARCHAR2(18) NOT NULL Data Key - Character

4 DATA_KEY1_DT Date(10) DATE Data Key Date

5 DATA_KEY1_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Key - Decimal

6 DATA_KEY2 Character(18) VARCHAR2(18) NOT NULL Data Key - Character

7 DATA_KEY2_DT Date(10) DATE Data Key Date

8 DATA_KEY2_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Key - Decimal

9 DATA_KEY3 Character(18) VARCHAR2(18) NOT NULL Data Key - Character

10 DATA_KEY3_DT Date(10) DATE Data Key - Date

11 DATA_KEY3_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Key - Decimal

12 DATA_KEY4 Character(18) VARCHAR2(18) NOT NULL Data Key - Character

13 DATA_KEY4_DT Date(10) DATE Data Key - Date

14 DATA_KEY4_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Key - Decimal

15 DATA_KEY5 Character(18) VARCHAR2(18) NOT NULL Data Key - Character

16 DATA_KEY5_DT Date(10) DATE Data Key - Date

17 DATA_KEY5_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Key - Decimal

18 DATA_VAL1 Character(18) VARCHAR2(18) NOT NULL Data Value - Character

19 DATA_VAL1_DT Date(10) DATE Data Value - Date

20 DATA_VAL1_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

21 DATA_VAL1_CURR Character(3) VARCHAR2(3) NOT NULL Currency Code for Bracket Data Value
Prompt Table: CURRENCY_CD_TBL

22 ENTRY_TYPE_VAL1 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
Prompt Table: GP_ENT_BRKTP_VW

23 PIN_VAL1_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
Prompt Table: %GP_EDIT_FLD1

24 DATA_VAL2 Character(18) VARCHAR2(18) NOT NULL Data Value - Character

25 DATA_VAL2_DT Date(10) DATE Data Value - Date

26 DATA_VAL2_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

27 DATA_VAL2_CURR Character(3) VARCHAR2(3) NOT NULL Currency Code for Bracket Data Value
Prompt Table: CURRENCY_CD_TBL

28 ENTRY_TYPE_VAL2 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
Prompt Table: GP_ENT_BRKTP_VW

29 PIN_VAL2_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
Prompt Table: %GP_EDIT_FLD2

30 DATA_VAL3 Character(18) VARCHAR2(18) NOT NULL Data Value - Character

31 DATA_VAL3_DT Date(10) DATE Data Value - Date

32 DATA_VAL3_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

33 DATA_VAL3_CURR Character(3) VARCHAR2(3) NOT NULL Currency Code for Bracket Data Value
Prompt Table: CURRENCY_CD_TBL

34 ENTRY_TYPE_VAL3 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
Prompt Table: GP_ENT_BRKTP_VW

35 PIN_VAL3_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
Prompt Table: %GP_EDIT_FLD3

36 DATA_VAL4 Character(18) VARCHAR2(18) NOT NULL Data Value - Character

37 DATA_VAL4_DT Date(10) DATE Data Value - Date

38 DATA_VAL4_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

39 DATA_VAL4_CURR Character(3) VARCHAR2(3) NOT NULL Currency Code for Bracket Data Value
Prompt Table: CURRENCY_CD_TBL

40 ENTRY_TYPE_VAL4 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
Prompt Table: GP_ENT_BRKTP_VW

41 PIN_VAL4_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
Prompt Table: %GP_EDIT_FLD4

42 DATA_VAL5 Character(18) VARCHAR2(18) NOT NULL Data Value - Character

43 DATA_VAL5_DT Date(10) DATE Data Value - Date

44 DATA_VAL5_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

45 DATA_VAL5_CURR Character(3) VARCHAR2(3) NOT NULL Currency Code for Bracket Data Value
Prompt Table: CURRENCY_CD_TBL

46 ENTRY_TYPE_VAL5 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
Prompt Table: GP_ENT_BRKTP_VW

47 PIN_VAL5_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
Prompt Table: %GP_EDIT_FLD5

48 DATA_VAL6 Character(18) VARCHAR2(18) NOT NULL Data Value - Character

49 DATA_VAL6_DT Date(10) DATE Data Value - Date

50 DATA_VAL6_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

51 DATA_VAL6_CURR Character(3) VARCHAR2(3) NOT NULL Currency Code for Bracket Data Value
Prompt Table: CURRENCY_CD_TBL

52 ENTRY_TYPE_VAL6 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
Prompt Table: GP_ENT_BRKTP_VW

53 PIN_VAL6_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
Prompt Table: %GP_EDIT_FLD6

54 DATA_VAL7 Character(18) VARCHAR2(18) NOT NULL Data Value - Character

55 DATA_VAL7_DT Date(10) DATE Data Value - Date

56 DATA_VAL7_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

57 DATA_VAL7_CURR Character(3) VARCHAR2(3) NOT NULL Currency Code for Bracket Data Value
Prompt Table: CURRENCY_CD_TBL

58 ENTRY_TYPE_VAL7 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
Prompt Table: GP_ENT_BRKTP_VW

59 PIN_VAL7_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
Prompt Table: %GP_EDIT_FLD7

60 DATA_VAL8 Character(18) VARCHAR2(18) NOT NULL Data Value - Character

61 DATA_VAL8_DT Date(10) DATE Data Value - Date

62 DATA_VAL8_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

63 DATA_VAL8_CURR Character(3) VARCHAR2(3) NOT NULL Currency Code for Bracket Data Value
Prompt Table: CURRENCY_CD_TBL

64 ENTRY_TYPE_VAL8 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value
Prompt Table: GP_ENT_BRKTP_VW

65 PIN_VAL8_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number
Prompt Table: %GP_EDIT_FLD8

#	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	DATA_KEY1	Character(18)	VARCHAR2(18) NOT NULL	Data Key - Character
4	DATA_KEY1_DT	Date(10)	DATE	Data Key Date
5	DATA_KEY1_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Key - Decimal
6	DATA_KEY2	Character(18)	VARCHAR2(18) NOT NULL	Data Key - Character
7	DATA_KEY2_DT	Date(10)	DATE	Data Key Date
8	DATA_KEY2_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Key - Decimal
9	DATA_KEY3	Character(18)	VARCHAR2(18) NOT NULL	Data Key - Character
10	DATA_KEY3_DT	Date(10)	DATE	Data Key - Date
11	DATA_KEY3_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Key - Decimal
12	DATA_KEY4	Character(18)	VARCHAR2(18) NOT NULL	Data Key - Character
13	DATA_KEY4_DT	Date(10)	DATE	Data Key - Date
14	DATA_KEY4_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Key - Decimal
15	DATA_KEY5	Character(18)	VARCHAR2(18) NOT NULL	Data Key - Character
16	DATA_KEY5_DT	Date(10)	DATE	Data Key - Date
17	DATA_KEY5_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Key - Decimal
18	DATA_VAL1	Character(18)	VARCHAR2(18) NOT NULL	Data Value - Character
19	DATA_VAL1_DT	Date(10)	DATE	Data Value - Date
20	DATA_VAL1_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal
21	DATA_VAL1_CURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code for Bracket Data Value Prompt Table: CURRENCY_CD_TBL
22	ENTRY_TYPE_VAL1	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Bracket Value Prompt Table: GP_ENT_BRKTP_VW
23	PIN_VAL1_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Value Element Number Prompt Table: %GP_EDIT_FLD1
24	DATA_VAL2	Character(18)	VARCHAR2(18) NOT NULL	Data Value - Character
25	DATA_VAL2_DT	Date(10)	DATE	Data Value - Date
26	DATA_VAL2_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal
27	DATA_VAL2_CURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code for Bracket Data Value Prompt Table: CURRENCY_CD_TBL
28	ENTRY_TYPE_VAL2	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Bracket Value Prompt Table: GP_ENT_BRKTP_VW
29	PIN_VAL2_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Value Element Number Prompt Table: %GP_EDIT_FLD2
30	DATA_VAL3	Character(18)	VARCHAR2(18) NOT NULL	Data Value - Character
31	DATA_VAL3_DT	Date(10)	DATE	Data Value - Date
32	DATA_VAL3_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal
33	DATA_VAL3_CURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code for Bracket Data Value Prompt Table: CURRENCY_CD_TBL
34	ENTRY_TYPE_VAL3	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Bracket Value Prompt Table: GP_ENT_BRKTP_VW
35	PIN_VAL3_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Value Element Number Prompt Table: %GP_EDIT_FLD3
36	DATA_VAL4	Character(18)	VARCHAR2(18) NOT NULL	Data Value - Character
37	DATA_VAL4_DT	Date(10)	DATE	Data Value - Date
38	DATA_VAL4_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal
39	DATA_VAL4_CURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code for Bracket Data Value Prompt Table: CURRENCY_CD_TBL
40	ENTRY_TYPE_VAL4	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Bracket Value Prompt Table: GP_ENT_BRKTP_VW
41	PIN_VAL4_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Value Element Number Prompt Table: %GP_EDIT_FLD4
42	DATA_VAL5	Character(18)	VARCHAR2(18) NOT NULL	Data Value - Character
43	DATA_VAL5_DT	Date(10)	DATE	Data Value - Date
44	DATA_VAL5_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal
45	DATA_VAL5_CURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code for Bracket Data Value Prompt Table: CURRENCY_CD_TBL
46	ENTRY_TYPE_VAL5	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Bracket Value Prompt Table: GP_ENT_BRKTP_VW
47	PIN_VAL5_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Value Element Number Prompt Table: %GP_EDIT_FLD5
48	DATA_VAL6	Character(18)	VARCHAR2(18) NOT NULL	Data Value - Character
49	DATA_VAL6_DT	Date(10)	DATE	Data Value - Date
50	DATA_VAL6_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal
51	DATA_VAL6_CURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code for Bracket Data Value Prompt Table: CURRENCY_CD_TBL
52	ENTRY_TYPE_VAL6	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Bracket Value Prompt Table: GP_ENT_BRKTP_VW
53	PIN_VAL6_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Value Element Number Prompt Table: %GP_EDIT_FLD6
54	DATA_VAL7	Character(18)	VARCHAR2(18) NOT NULL	Data Value - Character
55	DATA_VAL7_DT	Date(10)	DATE	Data Value - Date
56	DATA_VAL7_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal
57	DATA_VAL7_CURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code for Bracket Data Value Prompt Table: CURRENCY_CD_TBL
58	ENTRY_TYPE_VAL7	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Bracket Value Prompt Table: GP_ENT_BRKTP_VW
59	PIN_VAL7_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Value Element Number Prompt Table: %GP_EDIT_FLD7
60	DATA_VAL8	Character(18)	VARCHAR2(18) NOT NULL	Data Value - Character
61	DATA_VAL8_DT	Date(10)	DATE	Data Value - Date
62	DATA_VAL8_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal
63	DATA_VAL8_CURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code for Bracket Data Value Prompt Table: CURRENCY_CD_TBL
64	ENTRY_TYPE_VAL8	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Bracket Value Prompt Table: GP_ENT_BRKTP_VW
65	PIN_VAL8_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Value Element Number Prompt Table: %GP_EDIT_FLD8