GP_AUD_BRDTA_VW

(SQL View)
 Index Back

Bracket Value Entries

Bracket Value Entries

SELECT A.PIN_NUM ,A.EFFDT ,A.SEQ_NUM5 , CASE WHEN A.DATA_KEY1 <> ' ' THEN A.DATA_KEY1 WHEN A.DATA_KEY1_DT IS NOT NULL THEN to_char(A.DATA_KEY1_DT) WHEN A.DATA_KEY1_DEC >= 0 THEN to_char(A.DATA_KEY1_DEC) ELSE ' ' END , CASE WHEN A.DATA_KEY2 <> ' ' THEN A.DATA_KEY2 WHEN A.DATA_KEY2_DT IS NOT NULL THEN to_char(A.DATA_KEY2_DT) WHEN A.DATA_KEY2_DEC >= 0 THEN to_char(A.DATA_KEY2_DEC) ELSE ' ' END , CASE WHEN A.DATA_KEY3 <> ' ' THEN A.DATA_KEY3 WHEN A.DATA_KEY3_DT IS NOT NULL THEN to_char(A.DATA_KEY3_DT) WHEN A.DATA_KEY3_DEC >= 0 THEN to_char(A.DATA_KEY3_DEC) ELSE ' ' END , CASE WHEN A.DATA_KEY4 <> ' ' THEN A.DATA_KEY4 WHEN A.DATA_KEY4_DT IS NOT NULL THEN to_char(A.DATA_KEY4_DT) WHEN A.DATA_KEY4_DEC >= 0 THEN to_char(A.DATA_KEY4_DEC) ELSE ' ' END , CASE WHEN A.DATA_KEY5 <> ' ' THEN A.DATA_KEY5 WHEN A.DATA_KEY5_DT IS NOT NULL THEN to_char(A.DATA_KEY5_DT) WHEN A.DATA_KEY5_DEC >= 0 THEN to_char(A.DATA_KEY5_DEC) ELSE ' ' END , CASE WHEN A.DATA_VAL1 <> ' ' THEN A.DATA_VAL1 WHEN A.DATA_VAL1_DT IS NOT NULL THEN to_char(A.DATA_VAL1_DT) WHEN A.DATA_VAL1_DEC >= 0 THEN to_char(A.DATA_VAL1_DEC) ELSE ' ' END , CASE WHEN A.DATA_VAL2 <> ' ' THEN A.DATA_VAL2 WHEN A.DATA_VAL2_DT IS NOT NULL THEN to_char(A.DATA_VAL2_DT) WHEN A.DATA_VAL2_DEC >= 0 THEN to_char(A.DATA_VAL2_DEC) ELSE ' ' END , CASE WHEN A.DATA_VAL3 <> ' ' THEN A.DATA_VAL3 WHEN A.DATA_VAL3_DT IS NOT NULL THEN to_char(A.DATA_VAL3_DT) WHEN A.DATA_VAL3_DEC >= 0 THEN to_char(A.DATA_VAL3_DEC) ELSE ' ' END , CASE WHEN A.DATA_VAL4 <> ' ' THEN A.DATA_VAL4 WHEN A.DATA_VAL4_DT IS NOT NULL THEN to_char(A.DATA_VAL4_DT) WHEN A.DATA_VAL4_DEC >= 0 THEN to_char(A.DATA_VAL4_DEC) ELSE ' ' END , CASE WHEN A.DATA_VAL5 <> ' ' THEN A.DATA_VAL5 WHEN A.DATA_VAL5_DT IS NOT NULL THEN to_char(A.DATA_VAL5_DT) WHEN A.DATA_VAL5_DEC >= 0 THEN to_char(A.DATA_VAL5_DEC) ELSE ' ' END , CASE WHEN A.DATA_VAL6 <> ' ' THEN A.DATA_VAL6 WHEN A.DATA_VAL6_DT IS NOT NULL THEN to_char(A.DATA_VAL6_DT) WHEN A.DATA_VAL6_DEC >= 0 THEN to_char(A.DATA_VAL6_DEC) ELSE ' ' END , CASE WHEN A.DATA_VAL7 <> ' ' THEN A.DATA_VAL7 WHEN A.DATA_VAL7_DT IS NOT NULL THEN to_char(A.DATA_VAL7_DT) WHEN A.DATA_VAL7_DEC >= 0 THEN to_char(A.DATA_VAL7_DEC) ELSE ' ' END , CASE WHEN A.DATA_VAL8 <> ' ' THEN A.DATA_VAL8 WHEN A.DATA_VAL8_DT IS NOT NULL THEN to_char(A.DATA_VAL8_DT) WHEN A.DATA_VAL8_DEC >= 0 THEN to_char(A.DATA_VAL8_DEC) ELSE ' ' END FROM PS_GP_BRACKET_DTL A , PS_GP_BRACKET B WHERE A.PIN_NUM=B.PIN_NUM AND A.EFFDT=B.EFFDT

# 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_KEY2 Character(18) VARCHAR2(18) NOT NULL Data Key - Character
6 DATA_KEY3 Character(18) VARCHAR2(18) NOT NULL Data Key - Character
7 DATA_KEY4 Character(18) VARCHAR2(18) NOT NULL Data Key - Character
8 DATA_KEY5 Character(18) VARCHAR2(18) NOT NULL Data Key - Character
9 DATA_VAL1 Character(18) VARCHAR2(18) NOT NULL Data Value - Character
10 DATA_VAL2 Character(18) VARCHAR2(18) NOT NULL Data Value - Character
11 DATA_VAL3 Character(18) VARCHAR2(18) NOT NULL Data Value - Character
12 DATA_VAL4 Character(18) VARCHAR2(18) NOT NULL Data Value - Character
13 DATA_VAL5 Character(18) VARCHAR2(18) NOT NULL Data Value - Character
14 DATA_VAL6 Character(18) VARCHAR2(18) NOT NULL Data Value - Character
15 DATA_VAL7 Character(18) VARCHAR2(18) NOT NULL Data Value - Character
16 DATA_VAL8 Character(18) VARCHAR2(18) NOT NULL Data Value - Character