HRC_LOADER_BATCH_LINES_MSV

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name

BATCH_LINE_ID REQUEST_LINE_ID RUN_ID LINK_VALUE USER_SEQUENCE PROCESS_SEQUENCE ENTERPRISE_ID LINE_ACTION LINE_STATUS CURRENT_LEVEL NOTES ITEM_EFF_START_DATE ITEM_EFF_END_DATE ITEM_EFF_SEQ ITEM_EFF_SEQ_FLAG LEVEL_ID_01 LEVEL_ID_02 LEVEL_ID_03 LEVEL_ID_04 LEVEL_ID_05 LEVEL_ID_06 LEVEL_ID_07 LEVEL_ID_08 LEVEL_ID_09 LEVEL_ID_10 LEVEL_NAME_01 LEVEL_NAME_02 LEVEL_NAME_03 LEVEL_NAME_04 LEVEL_NAME_05 LEVEL_NAME_06 LEVEL_NAME_07 LEVEL_NAME_08 LEVEL_NAME_09 LEVEL_NAME_10 LEVEL_ALT_KEY_01 LEVEL_ALT_KEY_02 LEVEL_ALT_KEY_03 LEVEL_ALT_KEY_04 LEVEL_ALT_KEY_05 LEVEL_ALT_KEY_06 LEVEL_ALT_KEY_07 LEVEL_ALT_KEY_08 LEVEL_ALT_KEY_09 LEVEL_ALT_KEY_10 DESTINATION_AM_NAME DESTINATION_AM_CONFIG_NAME PVAL001 PVAL002 PVAL003 PVAL004 PVAL005 PVAL006 PVAL007 PVAL008 PVAL009 PVAL010 PVAL011 PVAL012 PVAL013 PVAL014 PVAL015 PVAL016 PVAL017 PVAL018 PVAL019 PVAL020 PVAL021 PVAL022 PVAL023 PVAL024 PVAL025 PVAL026 PVAL027 PVAL028 PVAL029 PVAL030 PVAL031 PVAL032 PVAL033 PVAL034 PVAL035 PVAL036 PVAL037 PVAL038 PVAL039 PVAL040 PVAL041 PVAL042 PVAL043 PVAL044 PVAL045 PVAL046 PVAL047 PVAL048 PVAL049 PVAL050 PVAL051 PVAL052 PVAL053 PVAL054 PVAL055 PVAL056 PVAL057 PVAL058 PVAL059 PVAL060 PVAL061 PVAL062 PVAL063 PVAL064 PVAL065 PVAL066 PVAL067 PVAL068 PVAL069 PVAL070 PVAL071 PVAL072 PVAL073 PVAL074 PVAL075 PVAL076 PVAL077 PVAL078 PVAL079 PVAL080 PVAL081 PVAL082 PVAL083 PVAL084 PVAL085 PVAL086 PVAL087 PVAL088 PVAL089 PVAL090 PVAL091 PVAL092 PVAL093 PVAL094 PVAL095 PVAL096 PVAL097 PVAL098 PVAL099 PVAL100 PVAL101 PVAL102 PVAL103 PVAL104 PVAL105 PVAL106 PVAL107 PVAL108 PVAL109 PVAL110 PVAL111 PVAL112 PVAL113 PVAL114 PVAL115 PVAL116 PVAL117 PVAL118 PVAL119 PVAL120 PVAL121 PVAL122 PVAL123 PVAL124 PVAL125 PVAL126 PVAL127 PVAL128 PVAL129 PVAL130 PVAL131 PVAL132 PVAL133 PVAL134 PVAL135 PVAL136 PVAL137 PVAL138 PVAL139 PVAL140 PVAL141 PVAL142 PVAL143 PVAL144 PVAL145 PVAL146 PVAL147 PVAL148 PVAL149 PVAL150 PVAL151 PVAL152 PVAL153 PVAL154 PVAL155 PVAL156 PVAL157 PVAL158 PVAL159 PVAL160 PVAL161 PVAL162 PVAL163 PVAL164 PVAL165 PVAL166 PVAL167 PVAL168 PVAL169 PVAL170 PVAL171 PVAL172 PVAL173 PVAL174 PVAL175 PVAL176 PVAL177 PVAL178 PVAL179 PVAL180 PVAL181 PVAL182 PVAL183 PVAL184 PVAL185 PVAL186 PVAL187 PVAL188 PVAL189 PVAL190 PVAL191 PVAL192 PVAL193 PVAL194 PVAL195 PVAL196 PVAL197 PVAL198 PVAL199 PVAL200 PVAL201 PVAL202 PVAL203 PVAL204 PVAL205 PVAL206 PVAL207 PVAL208 PVAL209 PVAL210 PVAL211 PVAL212 PVAL213 PVAL214 PVAL215 PVAL216 PVAL217 PVAL218 PVAL219 PVAL220 PVAL221 PVAL222 PVAL223 PVAL224 PVAL225 PVAL226 PVAL227 PVAL228 PVAL229 PVAL230 PDATE001 PDATE002 PDATE003 PDATE004 PDATE005 PDATE006 PDATE007 PDATE008 PDATE009 PDATE010 PDATE011 PDATE012 PDATE013 PDATE014 PDATE015 PDATE016 PDATE017 PDATE018 PDATE019 PDATE020 PDATE021 PDATE022 PDATE023 PDATE024 PDATE025 PDATE026 PDATE027 PDATE028 PDATE029 PDATE030 PLONGVAL001 ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 LOADER_BATCH_ID CHUNK_NUM JOB_ID CHANGED REQUEST_ID OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT HRC_LOADER_BATCH_LINES.BATCH_LINE_ID , HRC_LOADER_BATCH_LINES.REQUEST_LINE_ID , HRC_LOADER_BATCH_LINES.RUN_ID , HRC_LOADER_BATCH_LINES.LINK_VALUE , HRC_LOADER_BATCH_LINES.USER_SEQUENCE , HRC_LOADER_BATCH_LINES.PROCESS_SEQUENCE , HRC_LOADER_BATCH_LINES.ENTERPRISE_ID , HRC_LOADER_BATCH_LINES.LINE_ACTION , HRC_LOADER_BATCH_LINES.LINE_STATUS , HRC_LOADER_BATCH_LINES.CURRENT_LEVEL , HRC_LOADER_BATCH_LINES.NOTES , HRC_LOADER_BATCH_LINES.ITEM_EFF_START_DATE , HRC_LOADER_BATCH_LINES.ITEM_EFF_END_DATE , HRC_LOADER_BATCH_LINES.ITEM_EFF_SEQ , HRC_LOADER_BATCH_LINES.ITEM_EFF_SEQ_FLAG , HRC_LOADER_BATCH_LINES.LEVEL_ID_01 , HRC_LOADER_BATCH_LINES.LEVEL_ID_02 , HRC_LOADER_BATCH_LINES.LEVEL_ID_03 , HRC_LOADER_BATCH_LINES.LEVEL_ID_04 , HRC_LOADER_BATCH_LINES.LEVEL_ID_05 , HRC_LOADER_BATCH_LINES.LEVEL_ID_06 , HRC_LOADER_BATCH_LINES.LEVEL_ID_07 , HRC_LOADER_BATCH_LINES.LEVEL_ID_08 , HRC_LOADER_BATCH_LINES.LEVEL_ID_09 , HRC_LOADER_BATCH_LINES.LEVEL_ID_10 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_01 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_02 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_03 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_04 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_05 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_06 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_07 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_08 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_09 , HRC_LOADER_BATCH_LINES.LEVEL_NAME_10 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_01 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_02 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_03 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_04 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_05 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_06 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_07 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_08 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_09 , HRC_LOADER_BATCH_LINES.LEVEL_ALT_KEY_10 , HRC_LOADER_BATCH_LINES.DESTINATION_AM_NAME , HRC_LOADER_BATCH_LINES.DESTINATION_AM_CONFIG_NAME , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'AllTreeVO','Secure','FndTreeVersionVO','Secure','WorkerDi','Secure','WRAssignmentDi','Secure','AssignmentDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval001),Hrc_Loader_Batch_Lines.Pval001)As Varchar2(2000 Char)) Pval001 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'AllTreeVO','Secure','FndTreeVersionVO','Secure','WRAssignmentDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval002),Hrc_Loader_Batch_Lines.Pval002) As Varchar2(2000 Char)) Pval002 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'AllTreeVO','Secure','FndTreeVersionVO','Secure','WorkerDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval003),Hrc_Loader_Batch_Lines.Pval003) As Varchar2(2000 Char)) Pval003 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','ElementEntryValue','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'AllTreeVO','Secure','FndTreeVersionVO','Secure','WorkerDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval004),Hrc_Loader_Batch_Lines.Pval004) As Varchar2(2000 Char)) Pval004, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonEmail','Secure','PersonPhone','Secure','PersonPassport','Secure','PersonVisa','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'FndTreeVersionVO','Secure','WorkerDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval005),Hrc_Loader_Batch_Lines.Pval005) As Varchar2(2000 Char)) Pval005 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonReligion','Secure','PersonNationalIdentifier','Secure','PersonName', 'Secure','PersonVisa','Secure','PersonReligion','Secure','PersonEthnicity','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','FndTreeVersionVO','Secure','Person','Secure','WorkerDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval006), Hrc_Loader_Batch_Lines.Pval006) As Varchar2(2000 Char)) Pval006 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonNationalIdentifier','Secure','PersonPhone','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','FndTreeVersionVO','Secure','Location','Secure','Person','Secure','WorkerDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval007),Hrc_Loader_Batch_Lines.Pval007) As Varchar2(2000 Char)) Pval007 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonPhone','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonMaternityAbsenceEntry','Secure','SalaryVO','Secure','FndTreeVersionVO','Secure','PersonEntitlementDetail','Secure','Person','Secure','WorkerDi','Secure','Location','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval008),Hrc_Loader_Batch_Lines.Pval008) As Varchar2(2000 Char)) Pval008 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonName','Secure', Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonMaternityAbsenceEntry','Secure','SalaryVO','Secure','FndTreeVersionVO','Secure','WorkerDi','Secure','Location','Secure','PersonDi','Secure','LocationDi','Secure',Hrc_Loader_Batch_Lines.Pval009),Hrc_Loader_Batch_Lines.Pval009) As Varchar2(2000 Char)) Pval009 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonName','Secure', Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonMaternityAbsenceEntry','Secure','SalaryVO','Secure','Person','Secure','WorkerDi','Secure','Location','Secure','PersonDi','Secure','LocationDi','Secure',Hrc_Loader_Batch_Lines.Pval010),Hrc_Loader_Batch_Lines.Pval010) As Varchar2(2000 Char)) Pval010 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonName','Secure','PersonPhone','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','WorkerDi','Secure','Location','Secure','WorkRelationship','Secure','LocationDi','Secure',Hrc_Loader_Batch_Lines.Pval011),Hrc_Loader_Batch_Lines.Pval011) As Varchar2(2000 Char)) Pval011 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','ProfileItem','Secure','PersonAddress','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','PersonDi','Secure','Location','Secure','WorkRelationship','Secure',Hrc_Loader_Batch_Lines.Pval012),Hrc_Loader_Batch_Lines.Pval012) As Varchar2(2000 Char)) Pval012 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','ProfileItem','Secure','PersonAddress','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','FndTreeVersionVO','Secure','Person','Secure','Location','Secure','PersonDi','Secure','WorkRelationship','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval013),Hrc_Loader_Batch_Lines.Pval013) As Varchar2(2000 Char)) Pval013 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','ProfileItem','Secure','PersonAddress','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','FndTreeVersionVO','Secure','Location','Secure','WorkerDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval014),Hrc_Loader_Batch_Lines.Pval014) As Varchar2(2000 Char)) Pval014 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','FndTreeVersionVO','Secure','PersonEntitlementDetail','Secure','Location','Secure','WorkerDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval015),Hrc_Loader_Batch_Lines.Pval015) As Varchar2(2000 Char)) Pval015 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','FndTreeVersionVO','Secure','PersonDi','Secure','Location','Secure','WorkerDi','Secure','LocationDi','Secure',Hrc_Loader_Batch_Lines.Pval016),Hrc_Loader_Batch_Lines.Pval016) As Varchar2(2000 CHAR)) Pval016 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','PersonDi','Secure','Location','Secure','WorkerDi','Secure','LocationDi','Secure',Hrc_Loader_Batch_Lines.Pval017),Hrc_Loader_Batch_Lines.Pval017) As Varchar2(2000 Char)) Pval017 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonAddress','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonAbsenceEntry','Secure','SalaryVO','Secure','PersonDi','Secure','Location','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval018),Hrc_Loader_Batch_Lines.Pval018) As Varchar2(2000 Char)) Pval018 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','PersonName','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','PersonDi','Secure','Location','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval019),Hrc_Loader_Batch_Lines.Pval019) As Varchar2(2000 Char)) Pval019 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','ProfileItem','Secure','PersonAddress','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','Location','Secure','PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval020),Hrc_Loader_Batch_Lines.Pval020) As Varchar2(2000 Char)) Pval020 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','PersonAccrualDetail','Secure','Location','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval021),Hrc_Loader_Batch_Lines.Pval021) As Varchar2(2000 Char)) Pval021 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01 ,'SalaryVO','Secure','PersonDi','Secure','LocationDi','Secure',Hrc_Loader_Batch_Lines.Pval022),Hrc_Loader_Batch_Lines.Pval022) As Varchar2(2000 Char)) Pval022, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonMaternityAbsenceEntry','Secure','PersonAccrualDetail','Secure','SalaryVO','Secure','Location','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval023),Hrc_Loader_Batch_Lines.Pval023) As Varchar2(2000 Char)) Pval023 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','PersonDi','Secure','WorkerDi','Secure','LocationDi','Secure',Hrc_Loader_Batch_Lines.Pval024),Hrc_Loader_Batch_Lines.Pval024) As Varchar2(2000 CHAR)) Pval024, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure','ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','PersonDi','Secure','WorkerDi','Secure','LocationDi','Secure',Hrc_Loader_Batch_Lines.Pval025),Hrc_Loader_Batch_Lines.Pval025) As Varchar2(2000 Char)) Pval025 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'SalaryComponentVA','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure','LocationDi','Secure',Hrc_Loader_Batch_Lines.Pval026),Hrc_Loader_Batch_Lines.Pval026) As Varchar2(2000 Char)) Pval026 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval027),Hrc_Loader_Batch_Lines.Pval027) As Varchar2(2000 Char)) Pval027 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval028) As Varchar2(2000 Char)) Pval028 , Cast( Decode(Current_Level,1,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval029),Hrc_Loader_Batch_Lines.Pval029) As Varchar2(2000 CHAR)) Pval029, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'SalaryVO','Secure','PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval030),Hrc_Loader_Batch_Lines.Pval030) As Varchar2(2000 Char)) Pval030 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval031),Hrc_Loader_Batch_Lines.Pval031) As Varchar2(2000 Char)) Pval031 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval032),Hrc_Loader_Batch_Lines.Pval032) As Varchar2(2000 Char)) Pval032 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Hrc_Loader_Batch_Lines.Pval033) As Varchar2(2000 Char)) Pval033 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Hrc_Loader_Batch_Lines.Pval034) As Varchar2(2000 Char)) Pval034 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Hrc_Loader_Batch_Lines.Pval035) As Varchar2(2000 Char)) Pval035 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Hrc_Loader_Batch_Lines.Pval036) As Varchar2(2000 Char)) Pval036 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval037),Hrc_Loader_Batch_Lines.Pval037) As Varchar2(2000 Char)) Pval037 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'Location','Secure','PersonAbsenceEntry','Secure',Hrc_Loader_Batch_Lines.Pval038),Hrc_Loader_Batch_Lines.Pval038) As Varchar2(2000 Char)) Pval038 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'Location','Secure',Hrc_Loader_Batch_Lines.PVAL039),Hrc_Loader_Batch_Lines.PVAL039) As Varchar2(2000 Char)) PVAL039 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'Location','Secure',Hrc_Loader_Batch_Lines.PVAL040),Hrc_Loader_Batch_Lines.PVAL040) As Varchar2(2000 Char)) PVAL040 , cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'PersonDi','Secure','Location','Secure','WorkerDi','Secure',HRC_LOADER_BATCH_LINES.PVAL041),HRC_LOADER_BATCH_LINES.PVAL041) As Varchar2(2000 CHAR)) PVAL041 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'Location','Secure',Hrc_Loader_Batch_Lines.PVAL042),Hrc_Loader_Batch_Lines.PVAL042) As Varchar2(2000 Char)) PVAL042 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'Location','Secure',Hrc_Loader_Batch_Lines.PVAL043),Hrc_Loader_Batch_Lines.PVAL043) As Varchar2(2000 Char)) PVAL043 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure','Location','Secure',Hrc_Loader_Batch_Lines.Pval044),Hrc_Loader_Batch_Lines.Pval044) As Varchar2(2000 Char)) Pval044 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','Location','Secure',Hrc_Loader_Batch_Lines.Pval045),Hrc_Loader_Batch_Lines.Pval045) As Varchar2(2000 Char)) Pval045 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'Location','Secure',Hrc_Loader_Batch_Lines.PVAL046),Hrc_Loader_Batch_Lines.PVAL046) As Varchar2(2000 Char)) PVAL046 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'Location','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval047),Hrc_Loader_Batch_Lines.Pval047) As Varchar2(2000 Char)) Pval047 , cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'Location','Secure','PersonDi','Secure','WorkerDi','Secure',HRC_LOADER_BATCH_LINES.PVAL048),HRC_LOADER_BATCH_LINES.PVAL048) As Varchar2(2000 CHAR)) PVAL048 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'Location','Secure',Hrc_Loader_Batch_Lines.PVAL049),Hrc_Loader_Batch_Lines.PVAL049) As Varchar2(2000 Char)) PVAL049 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure','AssignmentDi','Secure',Hrc_Loader_Batch_Lines.Pval050),Hrc_Loader_Batch_Lines.Pval050) As Varchar2(2000 Char)) Pval050 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'Location','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.PVAL051),Hrc_Loader_Batch_Lines.PVAL051) As Varchar2(2000 Char)) PVAL051 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'AssignmentDi','Secure','PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval052),Hrc_Loader_Batch_Lines.Pval052) As Varchar2(2000 Char)) Pval052 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Hrc_Loader_Batch_Lines.Pval053) As Varchar2(2000 Char)) Pval053 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Null,Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','AssignmentDi','Secure',Hrc_Loader_Batch_Lines.Pval054),Hrc_Loader_Batch_Lines.Pval054) As Varchar2(2000 Char)) Pval054 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Hrc_Loader_Batch_Lines.Pval055) As Varchar2(2000 Char)) Pval055 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Hrc_Loader_Batch_Lines.Pval056) As Varchar2(2000 Char)) Pval056 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_02,'ProfileItem','Secure',Hrc_Loader_Batch_Lines.Pval057) As Varchar2(2000 Char)) Pval057 , HRC_LOADER_BATCH_LINES.PVAL058 PVAL058, HRC_LOADER_BATCH_LINES.PVAL059 PVAL059, HRC_LOADER_BATCH_LINES.PVAL060 PVAL060, HRC_LOADER_BATCH_LINES.PVAL061 PVAL061, HRC_LOADER_BATCH_LINES.PVAL062 PVAL062, Hrc_Loader_Batch_Lines.Pval063 Pval063, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval064) As Varchar2(2000 Char)) Pval064 , Cast(Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval065) As Varchar2(2000 Char)) Pval065 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval066) As Varchar2(2000 Char)) Pval066 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval067) As Varchar2(2000 Char)) Pval067 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval068) As Varchar2(2000 Char)) Pval068 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval069) As Varchar2(2000 Char)) Pval069 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval070) As Varchar2(2000 Char)) Pval070 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure','WRAssignmentDi','Secure',Hrc_Loader_Batch_Lines.Pval071) As Varchar2(2000 Char)) Pval071 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval072) As Varchar2(2000 Char)) Pval072 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval073) As Varchar2(2000 Char)) Pval073 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval074) As Varchar2(2000 CHAR)) Pval074 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval075) As Varchar2(2000 Char)) Pval075 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval076) As Varchar2(2000 Char)) Pval076 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval077) As Varchar2(2000 Char)) Pval077 , HRC_LOADER_BATCH_LINES.PVAL078 PVAL078 , Hrc_Loader_Batch_Lines.Pval079 Pval079 , cast(DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkerDi','Secure',HRC_LOADER_BATCH_LINES.PVAL080) As Varchar2(2000 CHAR)) PVAL080 , Hrc_Loader_Batch_Lines.Pval081 Pval081 , cast(DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'PersonDi','Secure',HRC_LOADER_BATCH_LINES.PVAL082) As Varchar2(2000 CHAR)) PVAL082 , HRC_LOADER_BATCH_LINES.PVAL083 PVAL083, Hrc_Loader_Batch_Lines.Pval084 Pval084, cast( DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkerDi','Secure',HRC_LOADER_BATCH_LINES.PVAL085) As Varchar2(2000 CHAR)) PVAL085 , Hrc_Loader_Batch_Lines.Pval086 Pval086 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval087) As Varchar2(2000 Char)) Pval087 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval088) As Varchar2(2000 Char)) Pval088 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure','WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval089) As Varchar2(2000 Char)) Pval089 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval090) As Varchar2(2000 Char)) Pval090 , cast( DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkerDi','Secure',HRC_LOADER_BATCH_LINES.PVAL091) As Varchar2(2000 CHAR)) PVAL091 , HRC_LOADER_BATCH_LINES.PVAL092 PVAL092, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval093) As Varchar2(2000 Char)) PVAL093, Hrc_Loader_Batch_Lines.Pval094 Pval094, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval095) As Varchar2(2000 Char)) Pval095 , HRC_LOADER_BATCH_LINES.PVAL096 PVAL096, HRC_LOADER_BATCH_LINES.PVAL097 PVAL097, Hrc_Loader_Batch_Lines.Pval098 Pval098, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval099) As Varchar2(2000 Char)) Pval099 , Hrc_Loader_Batch_Lines.Pval100 Pval100 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval101) As Varchar2(2000 Char)) Pval101 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WRAssignmentDi','Secure',Hrc_Loader_Batch_Lines.Pval102) As Varchar2(2000 Char)) Pval102 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval103) As Varchar2(2000 Char)) Pval103 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval104) As Varchar2(2000 Char)) Pval104 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval105) As Varchar2(2000 Char)) Pval105 , cast( DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'PersonDi','Secure',HRC_LOADER_BATCH_LINES.PVAL106) As Varchar2(2000 CHAR)) PVAL106 , Hrc_Loader_Batch_Lines.Pval107 Pval107 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval108) As Varchar2(2000 Char)) Pval108 , Hrc_Loader_Batch_Lines.Pval109 Pval109 , Hrc_Loader_Batch_Lines.Pval110 Pval110 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval111) As Varchar2(2000 Char)) Pval111 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval112) As Varchar2(2000 Char)) Pval112 , Hrc_Loader_Batch_Lines.Pval113 Pval113, Hrc_Loader_Batch_Lines.Pval114 Pval114, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'PersonDi','Secure',Hrc_Loader_Batch_Lines.Pval115) As Varchar2(2000 Char)) Pval115 , cast( DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'PersonDi','Secure',HRC_LOADER_BATCH_LINES.PVAL116) As Varchar2(2000 CHAR)) PVAL116 , HRC_LOADER_BATCH_LINES.PVAL117 PVAL117, HRC_LOADER_BATCH_LINES.PVAL118 PVAL118, HRC_LOADER_BATCH_LINES.PVAL119 PVAL119, HRC_LOADER_BATCH_LINES.PVAL120 PVAL120, HRC_LOADER_BATCH_LINES.PVAL121 PVAL121, HRC_LOADER_BATCH_LINES.PVAL122 PVAL122, HRC_LOADER_BATCH_LINES.PVAL123 PVAL123, HRC_LOADER_BATCH_LINES.PVAL124 PVAL124, Hrc_Loader_Batch_Lines.Pval125 Pval125, Hrc_Loader_Batch_Lines.Pval125 Pval126, HRC_LOADER_BATCH_LINES.PVAL127 PVAL127, HRC_LOADER_BATCH_LINES.PVAL128 PVAL128, HRC_LOADER_BATCH_LINES.PVAL129 PVAL129, HRC_LOADER_BATCH_LINES.PVAL130 PVAL130, HRC_LOADER_BATCH_LINES.PVAL131 PVAL131, HRC_LOADER_BATCH_LINES.PVAL132 PVAL132, HRC_LOADER_BATCH_LINES.PVAL133 PVAL133, HRC_LOADER_BATCH_LINES.PVAL134 PVAL134, HRC_LOADER_BATCH_LINES.PVAL135 PVAL135, HRC_LOADER_BATCH_LINES.PVAL136 PVAL136, HRC_LOADER_BATCH_LINES.PVAL137 PVAL137, HRC_LOADER_BATCH_LINES.PVAL138 PVAL138, HRC_LOADER_BATCH_LINES.PVAL139 PVAL139, HRC_LOADER_BATCH_LINES.PVAL140 PVAL140, HRC_LOADER_BATCH_LINES.PVAL141 PVAL141, HRC_LOADER_BATCH_LINES.PVAL142 PVAL142, HRC_LOADER_BATCH_LINES.PVAL143 PVAL143, HRC_LOADER_BATCH_LINES.PVAL144 PVAL144, HRC_LOADER_BATCH_LINES.PVAL145 PVAL145, HRC_LOADER_BATCH_LINES.PVAL146 PVAL146, HRC_LOADER_BATCH_LINES.PVAL147 PVAL147, HRC_LOADER_BATCH_LINES.PVAL148 PVAL148, HRC_LOADER_BATCH_LINES.PVAL149 PVAL149, HRC_LOADER_BATCH_LINES.PVAL150 PVAL150, HRC_LOADER_BATCH_LINES.PVAL151 PVAL151, HRC_LOADER_BATCH_LINES.PVAL152 PVAL152, HRC_LOADER_BATCH_LINES.PVAL153 PVAL153, HRC_LOADER_BATCH_LINES.PVAL154 PVAL154, HRC_LOADER_BATCH_LINES.PVAL155 PVAL155, HRC_LOADER_BATCH_LINES.PVAL156 PVAL156, HRC_LOADER_BATCH_LINES.PVAL157 PVAL157, HRC_LOADER_BATCH_LINES.PVAL158 PVAL158, HRC_LOADER_BATCH_LINES.PVAL159 PVAL159, HRC_LOADER_BATCH_LINES.PVAL160 PVAL160, HRC_LOADER_BATCH_LINES.PVAL161 PVAL161, HRC_LOADER_BATCH_LINES.PVAL162 PVAL162, HRC_LOADER_BATCH_LINES.PVAL163 PVAL163, HRC_LOADER_BATCH_LINES.PVAL164 PVAL164, HRC_LOADER_BATCH_LINES.PVAL165 PVAL165, HRC_LOADER_BATCH_LINES.PVAL166 PVAL166, HRC_LOADER_BATCH_LINES.PVAL167 PVAL167, HRC_LOADER_BATCH_LINES.PVAL168 PVAL168, Hrc_Loader_Batch_Lines.Pval169 Pval169, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval170) As Varchar2(2000 Char)) Pval170, HRC_LOADER_BATCH_LINES.PVAL171 PVAL171, HRC_LOADER_BATCH_LINES.PVAL172 PVAL172, HRC_LOADER_BATCH_LINES.PVAL173 PVAL173, HRC_LOADER_BATCH_LINES.PVAL174 PVAL174, HRC_LOADER_BATCH_LINES.PVAL175 PVAL175, HRC_LOADER_BATCH_LINES.PVAL176 PVAL176, HRC_LOADER_BATCH_LINES.PVAL177 PVAL177, HRC_LOADER_BATCH_LINES.PVAL178 PVAL178, HRC_LOADER_BATCH_LINES.PVAL179 PVAL179, HRC_LOADER_BATCH_LINES.PVAL180 PVAL180, HRC_LOADER_BATCH_LINES.PVAL181 PVAL181, HRC_LOADER_BATCH_LINES.PVAL182 PVAL182, HRC_LOADER_BATCH_LINES.PVAL183 PVAL183, HRC_LOADER_BATCH_LINES.PVAL184 PVAL184, HRC_LOADER_BATCH_LINES.PVAL185 PVAL185, HRC_LOADER_BATCH_LINES.PVAL186 PVAL186, HRC_LOADER_BATCH_LINES.PVAL187 PVAL187, HRC_LOADER_BATCH_LINES.PVAL188 PVAL188, HRC_LOADER_BATCH_LINES.PVAL189 PVAL189, HRC_LOADER_BATCH_LINES.PVAL190 PVAL190, HRC_LOADER_BATCH_LINES.PVAL191 PVAL191, HRC_LOADER_BATCH_LINES.PVAL192 PVAL192, HRC_LOADER_BATCH_LINES.PVAL193 PVAL193, HRC_LOADER_BATCH_LINES.PVAL194 PVAL194, HRC_LOADER_BATCH_LINES.PVAL195 PVAL195, HRC_LOADER_BATCH_LINES.PVAL196 PVAL196, HRC_LOADER_BATCH_LINES.PVAL197 PVAL197, HRC_LOADER_BATCH_LINES.PVAL198 PVAL198, HRC_LOADER_BATCH_LINES.PVAL199 PVAL199, Hrc_Loader_Batch_Lines.Pval200 Pval200, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval201) As Varchar2(2000 Char)) Pval201 , Hrc_Loader_Batch_Lines.Pval202 Pval202, Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval203) As Varchar2(2000 Char)) Pval203 , Hrc_Loader_Batch_Lines.Pval204 Pval204 , Cast( Decode(Hrc_Loader_Batch_Lines.Level_Name_01,'WorkerDi','Secure',Hrc_Loader_Batch_Lines.Pval205) As Varchar2(2000 Char)) Pval205 , HRC_LOADER_BATCH_LINES.PVAL206 PVAL206, HRC_LOADER_BATCH_LINES.PVAL207 PVAL207, HRC_LOADER_BATCH_LINES.PVAL208 PVAL208, HRC_LOADER_BATCH_LINES.PVAL209 PVAL209, HRC_LOADER_BATCH_LINES.PVAL210 PVAL210, HRC_LOADER_BATCH_LINES.PVAL211 PVAL211, HRC_LOADER_BATCH_LINES.PVAL212 PVAL212, HRC_LOADER_BATCH_LINES.PVAL213 PVAL213, HRC_LOADER_BATCH_LINES.PVAL214 PVAL214, HRC_LOADER_BATCH_LINES.PVAL215 PVAL215, HRC_LOADER_BATCH_LINES.PVAL216 PVAL216, HRC_LOADER_BATCH_LINES.PVAL217 PVAL217, HRC_LOADER_BATCH_LINES.PVAL218 PVAL218, HRC_LOADER_BATCH_LINES.PVAL219 PVAL219, HRC_LOADER_BATCH_LINES.PVAL220 PVAL220, HRC_LOADER_BATCH_LINES.PVAL221 PVAL221, HRC_LOADER_BATCH_LINES.PVAL222 PVAL222, HRC_LOADER_BATCH_LINES.PVAL223 PVAL223, HRC_LOADER_BATCH_LINES.PVAL224 PVAL224, HRC_LOADER_BATCH_LINES.PVAL225 PVAL225, HRC_LOADER_BATCH_LINES.PVAL226 PVAL226, HRC_LOADER_BATCH_LINES.PVAL227 PVAL227, HRC_LOADER_BATCH_LINES.PVAL228 PVAL228, HRC_LOADER_BATCH_LINES.PVAL229 PVAL229, HRC_LOADER_BATCH_LINES.PVAL230 PVAL230, /* DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_02,'PersonPassport','Secure',NULL,DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkRelationship','Secure',HRC_LOADER_BATCH_LINES.PDATE001),HRC_LOADER_BATCH_LINES.PDATE001) PDATE001 , DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_02,'PersonPassport','Secure',NULL,DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkRelationship','Secure',HRC_LOADER_BATCH_LINES.PDATE002),HRC_LOADER_BATCH_LINES.PDATE002) PDATE002 , DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkerDi','Secure','WRAssignmentDi','Secure','AssignmentDi','Secure','PersonDi','Secure',HRC_LOADER_BATCH_LINES.PDATE003) PDATE003 , DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_02,'PersonVisa','Secure',HRC_LOADER_BATCH_LINES.PDATE004) PDATE004 , DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_02,'PersonVisa','Secure',NULL,DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'Person','Secure',HRC_LOADER_BATCH_LINES.PDATE005),HRC_LOADER_BATCH_LINES.PDATE005) PDATE005 , DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_02,'PersonVisa','Secure',NULL,DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'Person','Secure',HRC_LOADER_BATCH_LINES.PDATE006),HRC_LOADER_BATCH_LINES.PDATE006) PDATE006 , DECODE(HRC_LOADER_BATCH_LINES.CURRENT_LEVEL,1,DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkRelationship','Secure',HRC_LOADER_BATCH_LINES.PDATE007),HRC_LOADER_BATCH_LINES.PDATE007) PDATE007 , HRC_LOADER_BATCH_LINES.PDATE008 PDATE008 , DECODE(HRC_LOADER_BATCH_LINES.CURRENT_LEVEL,1,DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkRelationship','Secure',HRC_LOADER_BATCH_LINES.PDATE009),HRC_LOADER_BATCH_LINES.PDATE009) PDATE009, DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'PersonDi','Secure',HRC_LOADER_BATCH_LINES.PDATE010) PDATE010, DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkerDi','Secure','PersonDi','Secure',HRC_LOADER_BATCH_LINES.PDATE011) PDATE011, DECODE(HRC_LOADER_BATCH_LINES.LEVEL_NAME_01,'WorkerDi','Secure',HRC_LOADER_BATCH_LINES.PDATE012) PDATE012, HRC_LOADER_BATCH_LINES.PDATE013 PDATE013, HRC_LOADER_BATCH_LINES.PDATE014 PDATE014, HRC_LOADER_BATCH_LINES.PDATE015 PDATE015, HRC_LOADER_BATCH_LINES.PDATE016 PDATE016, HRC_LOADER_BATCH_LINES.PDATE017 PDATE017, HRC_LOADER_BATCH_LINES.PDATE018 PDATE018, HRC_LOADER_BATCH_LINES.PDATE019 PDATE019, HRC_LOADER_BATCH_LINES.PDATE020 PDATE020, HRC_LOADER_BATCH_LINES.PDATE021 PDATE021, HRC_LOADER_BATCH_LINES.PDATE022 PDATE022, HRC_LOADER_BATCH_LINES.PDATE023 PDATE023, HRC_LOADER_BATCH_LINES.PDATE024 PDATE024, HRC_LOADER_BATCH_LINES.PDATE025 PDATE025, HRC_LOADER_BATCH_LINES.PDATE026 PDATE026, HRC_LOADER_BATCH_LINES.PDATE027 PDATE027, HRC_LOADER_BATCH_LINES.PDATE028 PDATE028, HRC_LOADER_BATCH_LINES.PDATE029 PDATE029, HRC_LOADER_BATCH_LINES.PDATE030 PDATE030, */ NVL2(HRC_LOADER_BATCH_LINES.PDATE001, 'Secure', NULL) PDATE001, NVL2(HRC_LOADER_BATCH_LINES.PDATE002, 'Secure', NULL) PDATE002, NVL2(HRC_LOADER_BATCH_LINES.PDATE003,'Secure',NULL) PDATE003, NVL2(HRC_LOADER_BATCH_LINES.PDATE004, 'Secure', NULL) PDATE004, NVL2(HRC_LOADER_BATCH_LINES.PDATE005, 'Secure', NULL) PDATE005, NVL2(HRC_LOADER_BATCH_LINES.PDATE006, 'Secure', NULL) PDATE006, NVL2(HRC_LOADER_BATCH_LINES.PDATE007, 'Secure', NULL) PDATE007, NVL2(HRC_LOADER_BATCH_LINES.PDATE008, 'Secure', NULL) PDATE008, NVL2(HRC_LOADER_BATCH_LINES.PDATE009, 'Secure', NULL) PDATE009, NVL2(HRC_LOADER_BATCH_LINES.PDATE010,'Secure',NULL) PDATE010, NVL2(HRC_LOADER_BATCH_LINES.PDATE011,'Secure',NULL) PDATE011, NVL2(HRC_LOADER_BATCH_LINES.PDATE012,'Secure',NULL) PDATE012, HRC_LOADER_BATCH_LINES.PDATE013 PDATE013, HRC_LOADER_BATCH_LINES.PDATE014 PDATE014, HRC_LOADER_BATCH_LINES.PDATE015 PDATE015, HRC_LOADER_BATCH_LINES.PDATE016 PDATE016, HRC_LOADER_BATCH_LINES.PDATE017 PDATE017, HRC_LOADER_BATCH_LINES.PDATE018 PDATE018, HRC_LOADER_BATCH_LINES.PDATE019 PDATE019, HRC_LOADER_BATCH_LINES.PDATE020 PDATE020, HRC_LOADER_BATCH_LINES.PDATE021 PDATE021, HRC_LOADER_BATCH_LINES.PDATE022 PDATE022, HRC_LOADER_BATCH_LINES.PDATE023 PDATE023, HRC_LOADER_BATCH_LINES.PDATE024 PDATE024, HRC_LOADER_BATCH_LINES.PDATE025 PDATE025, HRC_LOADER_BATCH_LINES.PDATE026 PDATE026, HRC_LOADER_BATCH_LINES.PDATE027 PDATE027, HRC_LOADER_BATCH_LINES.PDATE028 PDATE028, Hrc_Loader_Batch_Lines.Pdate029 Pdate029, Hrc_Loader_Batch_Lines.Pdate030 Pdate030, HRC_LOADER_BATCH_LINES.PLONGVAL001 PLONGVAL001 , HRC_LOADER_BATCH_LINES.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , HRC_LOADER_BATCH_LINES.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, HRC_LOADER_BATCH_LINES.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, HRC_LOADER_BATCH_LINES.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, HRC_LOADER_BATCH_LINES.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, HRC_LOADER_BATCH_LINES.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, HRC_LOADER_BATCH_LINES.LOADER_BATCH_ID LOADER_BATCH_ID, HRC_LOADER_BATCH_LINES.CHUNK_NUM CHUNK_NUM , HRC_LOADER_BATCH_LINES.JOB_ID JOB_ID , HRC_LOADER_BATCH_LINES.CHANGED CHANGED, HRC_LOADER_BATCH_LINES.REQUEST_ID REQUEST_ID, Hrc_Loader_Batch_Lines.Object_Version_Number Object_Version_Number From Fusion.Hrc_Loader_Batch_Lines