GP_PKG_BR2_VW (SQL View)	Index Back
Bracket Value Entries Global Payroll Package Bracket Value Entries View Record.

GP_PKG_BR2_VW

(SQL View)

Bracket Value Entries

Global Payroll Package Bracket Value Entries View Record.

SELECT PIN_NUM + 50000000 , EFFDT , SEQ_NUM5 , 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

# 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
Default Value: %date

3 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number

4 DATA_KEY1 Character(18) VARCHAR2(18) NOT NULL Data Key - Character

5 DATA_KEY1_DT Date(10) DATE Data Key Date

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

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

8 DATA_KEY2_DT Date(10) DATE Data Key Date

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

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

11 DATA_KEY3_DT Date(10) DATE Data Key - Date

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

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

14 DATA_KEY4_DT Date(10) DATE Data Key - Date

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

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

17 DATA_KEY5_DT Date(10) DATE Data Key - Date

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

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

20 DATA_VAL1_DT Date(10) DATE Data Value - Date

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

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

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

24 PIN_VAL1_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

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

26 DATA_VAL2_DT Date(10) DATE Data Value - Date

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

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

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

30 PIN_VAL2_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

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

32 DATA_VAL3_DT Date(10) DATE Data Value - Date

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

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

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

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

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

38 DATA_VAL4_DT Date(10) DATE Data Value - Date

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

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

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

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

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

44 DATA_VAL5_DT Date(10) DATE Data Value - Date

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

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

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

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

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

50 DATA_VAL6_DT Date(10) DATE Data Value - Date

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

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

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

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

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

56 DATA_VAL7_DT Date(10) DATE Data Value - Date

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

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

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

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

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

62 DATA_VAL8_DT Date(10) DATE Data Value - Date

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

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

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

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

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