Component to peoplesoft field description

Summary:

Component to peoplesoft field description. useful in analyzing records on field.

Component to peoplesoft field description

RahulAgrawal 24 Apr 2013 10:50

SELECT DISTINCT RECNAME,
Fieldname,
lbltext,
DECODE(bitand(fielduse, 1), 1, 'On', 'Off') DISPLAY_ONLY,
DECODE(bitand(fielduse, 2), 2, 'On', 'Off') INVISIBLE,
DECODE(bitand(fielduse, 4), 4, 'On', 'Off') UNKNOWN_4,
DECODE(bitand(fielduse, 8), 8, 'On', 'Off') DISPLAY_CONTROL,
DECODE(bitand(fielduse, 16), 16, 'On', 'Off') RELATED_DISPLAY,
DECODE(bitand(fielduse, 32), 32, 'On', 'Off') MULTI_CURRENCY,
DECODE(bitand(fielduse, 64), 64, 'On', 'Off') NO_AUTO_SELECT,
DECODE(bitand(fielduse, 128), 128, 'On', 'Off') NO_AUTO_UPDATE,
DECODE(bitand(fielduse, 256), 256, 'On', 'Off') NO_ROW_INSERT,
DECODE(bitand(fielduse, 512), 512, 'On', 'Off') NO_ROW_DELETE,
DECODE(bitand(fielduse, 1024), 1024, 'On', 'Off') SHOW_LABEL,
DECODE(bitand(fielduse, 2048), 2048, 'On', 'Off') FREEZE_GRID_COL,
DECODE(bitand(fielduse, 4096), 4096, 'On', 'Off') ODD_EVEN_ROW_STYLE,
DECODE(bitand(fielduse, 8192), 8192, 'On', 'Off') UNKNOWN_8192,
DECODE(bitand(fielduse, 16384), 16384, 'On', 'Off') UNKNOWN_16384,
DECODE(bitand(fielduse, 32768), 32768, 'On', 'Off') UNKNOWN_32768,
DECODE(bitand(fielduse, 65536), 65536, 'On', 'Off') UNKNOWN_65536,
DECODE(bitand(fielduse, 131072), 131072, 'On', 'Off') UNKNOWN_131072,
DECODE(bitand(fielduse, 262144), 262144, 'On', 'Off') ENABLE_WHEN_DISPLAY_ONLY,
DECODE(bitand(fielduse, 524288), 524288, 'On', 'Off') UNKNOWN_524288,
DECODE(bitand(fielduse, 1048576), 1048576, 'On', 'Off') ROW_DELETE,
DECODE(bitand(fielduse, 2097152), 2097152, 'On', 'Off') ROW_INSERT,
DECODE(bitand(fielduse, 4194304), 4194304, 'On', 'Off') NEXT_PAGE,
DECODE(bitand(fielduse, 8388608), 8388608, 'On', 'Off') PREVIOUS_PAGE,
DECODE(bitand(fielduse, 16777216), 16777216, 'On', 'Off') UNKNOWN_16777216,
DECODE(bitand(fielduse, 33554432), 33554432, 'On', 'Off') SHOW_ROW_COUNTER,
DECODE(bitand(fielduse, 67108864), 67108864, 'On', 'Off') HIDE_BORDER,
DECODE(bitand(fielduse, 134217728), 134217728, 'On', 'Off') UNLIMITED_OCCURS,
DECODE(bitand(fielduse, 268435456), 268435456, 'On', 'Off') FIXED_HEIGHT,
DECODE(bitand(fielduse, 536870912), 536870912, 'On', 'Off') UNKNOWN_536870912,
DECODE(bitand(fielduse, 1073741824), 1073741824, 'On', 'Off') TOP,
DECODE(bitand(fielduse, 2147483648), 2147483648, 'On', 'Off') BOTTOM
FROM PSPNLFIELD
WHERE PNLNAME IN
(SELECT DISTINCT B.PNLNAME
FROM PSPNLGROUP A,
PSPNLFIELD B
WHERE ( A.PNLNAME = B.PNLNAME
OR A.PNLNAME = B.SUBPNLNAME )
AND A.PNLGRPNAME ='IB_MONITOR_DET'
AND RECNAME <> ' '
)
UNION
SELECT DISTINCT RECNAME,
Fieldname,
lbltext,
DECODE(bitand(fielduse, 1), 1, 'On', 'Off') DISPLAY_ONLY,
DECODE(bitand(fielduse, 2), 2, 'On', 'Off') INVISIBLE,
DECODE(bitand(fielduse, 4), 4, 'On', 'Off') UNKNOWN_4,
DECODE(bitand(fielduse, 8), 8, 'On', 'Off') DISPLAY_CONTROL,
DECODE(bitand(fielduse, 16), 16, 'On', 'Off') RELATED_DISPLAY,
DECODE(bitand(fielduse, 32), 32, 'On', 'Off') MULTI_CURRENCY,
DECODE(bitand(fielduse, 64), 64, 'On', 'Off') NO_AUTO_SELECT,
DECODE(bitand(fielduse, 128), 128, 'On', 'Off') NO_AUTO_UPDATE,
DECODE(bitand(fielduse, 256), 256, 'On', 'Off') NO_ROW_INSERT,
DECODE(bitand(fielduse, 512), 512, 'On', 'Off') NO_ROW_DELETE,
DECODE(bitand(fielduse, 1024), 1024, 'On', 'Off') SHOW_LABEL,
DECODE(bitand(fielduse, 2048), 2048, 'On', 'Off') FREEZE_GRID_COL,
DECODE(bitand(fielduse, 4096), 4096, 'On', 'Off') ODD_EVEN_ROW_STYLE,
DECODE(bitand(fielduse, 8192), 8192, 'On', 'Off') UNKNOWN_8192,
DECODE(bitand(fielduse, 16384), 16384, 'On', 'Off') UNKNOWN_16384,
DECODE(bitand(fielduse, 32768), 32768, 'On', 'Off') UNKNOWN_32768,
DECODE(bitand(fielduse, 65536), 65536, 'On', 'Off') UNKNOWN_65536,
DECODE(bitand(fielduse, 131072), 131072, 'On', 'Off') UNKNOWN_131072,
DECODE(bitand(fielduse, 262144), 262144, 'On', 'Off') ENABLE_WHEN_DISPLAY_ONLY,
DECODE(bitand(fielduse, 524288), 524288, 'On', 'Off') UNKNOWN_524288,
DECODE(bitand(fielduse, 1048576), 1048576, 'On', 'Off') ROW_DELETE,
DECODE(bitand(fielduse, 2097152), 2097152, 'On', 'Off') ROW_INSERT,
DECODE(bitand(fielduse, 4194304), 4194304, 'On', 'Off') NEXT_PAGE,
DECODE(bitand(fielduse, 8388608), 8388608, 'On', 'Off') PREVIOUS_PAGE,
DECODE(bitand(fielduse, 16777216), 16777216, 'On', 'Off') UNKNOWN_16777216,
DECODE(bitand(fielduse, 33554432), 33554432, 'On', 'Off') SHOW_ROW_COUNTER,
DECODE(bitand(fielduse, 67108864), 67108864, 'On', 'Off') HIDE_BORDER,
DECODE(bitand(fielduse, 134217728), 134217728, 'On', 'Off') UNLIMITED_OCCURS,
DECODE(bitand(fielduse, 268435456), 268435456, 'On', 'Off') FIXED_HEIGHT,
DECODE(bitand(fielduse, 536870912), 536870912, 'On', 'Off') UNKNOWN_536870912,
DECODE(bitand(fielduse, 1073741824), 1073741824, 'On', 'Off') TOP,
DECODE(bitand(fielduse, 2147483648), 2147483648, 'On', 'Off') BOTTOM
FROM PSPNLFIELD
WHERE PNLNAME IN
(SELECT DISTINCT B.SUBPNLNAME
FROM PSPNLGROUP A,
PSPNLFIELD B
WHERE ( A.PNLNAME = B.PNLNAME
OR A.PNLNAME = B.SUBPNLNAME )
AND A.PNLGRPNAME ='IB_MONITOR_DET'
)