eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BEN.BEN_LOA_RSN_RT_F#

Source

View Text - Preformatted


select LOA_RSN_RT_ID LOA_RSN_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EXCLD_FLAG EXCLD_FLAG, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID, ABS_ATTENDANCE_REASON_ID ABS_ATTENDANCE_REASON_ID, LAR_ATTRIBUTE_CATEGORY LAR_ATTRIBUTE_CATEGORY, LAR_ATTRIBUTE1 LAR_ATTRIBUTE1, LAR_ATTRIBUTE2 LAR_ATTRIBUTE2, LAR_ATTRIBUTE3 LAR_ATTRIBUTE3, LAR_ATTRIBUTE4 LAR_ATTRIBUTE4, LAR_ATTRIBUTE5 LAR_ATTRIBUTE5, LAR_ATTRIBUTE6 LAR_ATTRIBUTE6, LAR_ATTRIBUTE7 LAR_ATTRIBUTE7, LAR_ATTRIBUTE8 LAR_ATTRIBUTE8, LAR_ATTRIBUTE9 LAR_ATTRIBUTE9, LAR_ATTRIBUTE10 LAR_ATTRIBUTE10, LAR_ATTRIBUTE11 LAR_ATTRIBUTE11, LAR_ATTRIBUTE12 LAR_ATTRIBUTE12, LAR_ATTRIBUTE13 LAR_ATTRIBUTE13, LAR_ATTRIBUTE14 LAR_ATTRIBUTE14, LAR_ATTRIBUTE15 LAR_ATTRIBUTE15, LAR_ATTRIBUTE16 LAR_ATTRIBUTE16, LAR_ATTRIBUTE17 LAR_ATTRIBUTE17, LAR_ATTRIBUTE18 LAR_ATTRIBUTE18, LAR_ATTRIBUTE19 LAR_ATTRIBUTE19, LAR_ATTRIBUTE20 LAR_ATTRIBUTE20, LAR_ATTRIBUTE21 LAR_ATTRIBUTE21, LAR_ATTRIBUTE22 LAR_ATTRIBUTE22, LAR_ATTRIBUTE23 LAR_ATTRIBUTE23, LAR_ATTRIBUTE24 LAR_ATTRIBUTE24, LAR_ATTRIBUTE25 LAR_ATTRIBUTE25, LAR_ATTRIBUTE26 LAR_ATTRIBUTE26, LAR_ATTRIBUTE27 LAR_ATTRIBUTE27, LAR_ATTRIBUTE28 LAR_ATTRIBUTE28, LAR_ATTRIBUTE29 LAR_ATTRIBUTE29, LAR_ATTRIBUTE30 LAR_ATTRIBUTE30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ORDR_NUM ORDR_NUM, LOA_RSN_CD LOA_RSN_CD from "BEN"."BEN_LOA_RSN_RT_F"

View Text - HTML Formatted

SELECT LOA_RSN_RT_ID LOA_RSN_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EXCLD_FLAG EXCLD_FLAG
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID
, ABS_ATTENDANCE_REASON_ID ABS_ATTENDANCE_REASON_ID
, LAR_ATTRIBUTE_CATEGORY LAR_ATTRIBUTE_CATEGORY
, LAR_ATTRIBUTE1 LAR_ATTRIBUTE1
, LAR_ATTRIBUTE2 LAR_ATTRIBUTE2
, LAR_ATTRIBUTE3 LAR_ATTRIBUTE3
, LAR_ATTRIBUTE4 LAR_ATTRIBUTE4
, LAR_ATTRIBUTE5 LAR_ATTRIBUTE5
, LAR_ATTRIBUTE6 LAR_ATTRIBUTE6
, LAR_ATTRIBUTE7 LAR_ATTRIBUTE7
, LAR_ATTRIBUTE8 LAR_ATTRIBUTE8
, LAR_ATTRIBUTE9 LAR_ATTRIBUTE9
, LAR_ATTRIBUTE10 LAR_ATTRIBUTE10
, LAR_ATTRIBUTE11 LAR_ATTRIBUTE11
, LAR_ATTRIBUTE12 LAR_ATTRIBUTE12
, LAR_ATTRIBUTE13 LAR_ATTRIBUTE13
, LAR_ATTRIBUTE14 LAR_ATTRIBUTE14
, LAR_ATTRIBUTE15 LAR_ATTRIBUTE15
, LAR_ATTRIBUTE16 LAR_ATTRIBUTE16
, LAR_ATTRIBUTE17 LAR_ATTRIBUTE17
, LAR_ATTRIBUTE18 LAR_ATTRIBUTE18
, LAR_ATTRIBUTE19 LAR_ATTRIBUTE19
, LAR_ATTRIBUTE20 LAR_ATTRIBUTE20
, LAR_ATTRIBUTE21 LAR_ATTRIBUTE21
, LAR_ATTRIBUTE22 LAR_ATTRIBUTE22
, LAR_ATTRIBUTE23 LAR_ATTRIBUTE23
, LAR_ATTRIBUTE24 LAR_ATTRIBUTE24
, LAR_ATTRIBUTE25 LAR_ATTRIBUTE25
, LAR_ATTRIBUTE26 LAR_ATTRIBUTE26
, LAR_ATTRIBUTE27 LAR_ATTRIBUTE27
, LAR_ATTRIBUTE28 LAR_ATTRIBUTE28
, LAR_ATTRIBUTE29 LAR_ATTRIBUTE29
, LAR_ATTRIBUTE30 LAR_ATTRIBUTE30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ORDR_NUM ORDR_NUM
, LOA_RSN_CD LOA_RSN_CD
FROM "BEN"."BEN_LOA_RSN_RT_F"