[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_PP_ENH_AUDIT_DN_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View for providing content into the Compensation Workbench Post Process Enhanced Audit download.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DLSECUREDNAMEPR | VARCHAR2 | (240) | Person's full name | |
DLNUMPR | VARCHAR2 | (30) | Employee Number | |
DLSTATUSPR | VARCHAR2 | (7) | Status | |
DLMESSAGEPR | VARCHAR2 | (2000) | Error Message | |
DLCOUNTRYPR | VARCHAR2 | (80) | Country | |
DLBGNAMEPR | VARCHAR2 | (240) | Business group | |
DLLOCALPLANPR | VARCHAR2 | (240) | Local Plan | |
DLELIGPR | VARCHAR2 | (80) | Eligibility (Y or N) | |
DLEVTPR | VARCHAR2 | (80) | Life event status | |
DLNAMESALPL | VARCHAR2 | (240) | Plan Name | |
DLCURRENCYPL | VARCHAR2 | (80) | Currency | |
DLBASESALARYPL | NUMBER | Base Salary | ||
DLELIGSALARYPL | NUMBER | Eligible Salary | ||
DLCWBAMTPL | NUMBER | Amount | ||
DLPERCENTPL | NUMBER | Percent | ||
DLBASISPL | VARCHAR2 | (30) | Base Salary Frequency | |
DLPAYFACTORPL | NUMBER | Pay Annualization Factor | ||
DLPLANFACTORPL | NUMBER | Annualization factor defined for plan | ||
DLFACTORPL | NUMBER | Conversion Factor | ||
DLADJAMTPL | NUMBER | Adjusted amount | ||
DLPREVSALPL | NUMBER | Previous salary | ||
DLCHANGEPL | NUMBER | Amount Posted | ||
DLNEWSALPL | NUMBER | New Salary | ||
DLXRATEPL | NUMBER | Exchange Rate for the plan | ||
DLCORPBASESALPL | NUMBER | Base Salary in Preferred Currency | ||
DLCORPELIGSALPL | NUMBER | Eligible Salary in Preferred Currency | ||
DLCORPCWBAMTPL | NUMBER | Amount in Preferred Currency | ||
DLCORPADJAMTPL | NUMBER | Adjusted amount in Preferred Currency | ||
DLCORPPREVSALPL | NUMBER | Previous Salary in Preferred Currency | ||
DLCORPCHANGEPL | NUMBER | Amount posted in preferred currency | ||
DLCORPNEWSALPL | NUMBER | New Salary in preferred currency | ||
DLREASONPL | VARCHAR2 | (80) | Reason | |
DLEFFECTIVEDTPL | DATE | Effective date | ||
DLOPTELIGPL | VARCHAR2 | (80) | Eligible (Y or N) for Option | |
DLFTEFACTORPL | NUMBER | FTE factor for plan | ||
DLNAMESALOPT1 | VARCHAR2 | (240) | Option 1 Name | |
DLCURRENCYOPT1 | VARCHAR2 | (80) | Currency for option 1 | |
DLBASESALARYOPT1 | NUMBER | Base salary for option 1 | ||
DLELIGSALARYOPT1 | NUMBER | Eligible salary for option 1 | ||
DLCWBAMTOPT1 | NUMBER | Amount for option 1 | ||
DLPERCENTOPT1 | NUMBER | Percent for option 1 | ||
DLBASISOPT1 | VARCHAR2 | (30) | Base salary frequency for option 1 | |
DLPAYFACTOROPT1 | NUMBER | Pay annualization factor for option 1 | ||
DLPLANFACTOROPT1 | NUMBER | Plan annualization factor for option 1 | ||
DLFACTOROPT1 | NUMBER | Conversion factor for option 1 | ||
DLADJAMTOPT1 | NUMBER | Adjusted amount for option 1 | ||
DLPREVSALOPT1 | NUMBER | Previous salary for option 1 | ||
DLCHANGEOPT1 | NUMBER | Amount posted for option 1 | ||
DLNEWSALOPT1 | NUMBER | New salary for option 1 | ||
DLXRATEOPT1 | NUMBER | Exchange rate for option 1 | ||
DLCORPBASESALOPT1 | NUMBER | Base salary in preferred currency for option 1 | ||
DLCORPELIGSALOPT1 | NUMBER | Eligible salary in preferred currency for option 1 | ||
DLCORPCWBAMTOPT1 | NUMBER | Amount in preferred currency for option 1 | ||
DLCORPADJAMTOPT1 | NUMBER | Adjusted amount in preferred currency for option 1 | ||
DLCORPPREVSALOPT1 | NUMBER | Previous salary in preferred currency for option 1 | ||
DLCORPCHANGEOPT1 | NUMBER | Amount posted in preferred currency for option 1 | ||
DLCORPNEWSALOPT1 | NUMBER | New salary in preferred currency for option 1 | ||
DLREASONOPT1 | VARCHAR2 | (80) | Reason for option 1 | |
DLEFFECTIVEDTOPT1 | DATE | Effective date for option 1 | ||
DLOPTELIGOPT1 | VARCHAR2 | (80) | Eligible for Option 1 | |
DLFTEFACTOROPT1 | NUMBER | FTE Factor for option 1 | ||
DLNAMESALOPT2 | VARCHAR2 | (240) | Option 2 Name | |
DLCURRENCYOPT2 | VARCHAR2 | (80) | Currency for option 2 | |
DLBASESALARYOPT2 | NUMBER | Base salary for option 2 | ||
DLELIGSALARYOPT2 | NUMBER | Eligible salary for option 2 | ||
DLCWBAMTOPT2 | NUMBER | Amount for option 2 | ||
DLPERCENTOPT2 | NUMBER | Percent for option 2 | ||
DLBASISOPT2 | VARCHAR2 | (30) | Base salary frequency for option 2 | |
DLPAYFACTOROPT2 | NUMBER | Pay annualization factor for option 2 | ||
DLPLANFACTOROPT2 | NUMBER | Plan annualization factor for option 2 | ||
DLFACTOROPT2 | NUMBER | Conversion factor for option 2 | ||
DLADJAMTOPT2 | NUMBER | Adjusted amount for option 2 | ||
DLPREVSALOPT2 | NUMBER | Previous salary for option 2 | ||
DLCHANGEOPT2 | NUMBER | Amount posted for option 2 | ||
DLNEWSALOPT2 | NUMBER | New salary for option 2 | ||
DLXRATEOPT2 | NUMBER | Exchange rate for option 2 | ||
DLCORPBASESALOPT2 | NUMBER | Base salary in preferred currency for option 2 | ||
DLCORPELIGSALOPT2 | NUMBER | Eligible salary in preferred currency for option 2 | ||
DLCORPCWBAMTOPT2 | NUMBER | Amount in preferred currency for option 2 | ||
DLCORPADJAMTOPT2 | NUMBER | Adjusted amount in preferred currency for option 2 | ||
DLCORPPREVSALOPT2 | NUMBER | Previous salary in preferred currency for option 2 | ||
DLCORPCHANGEOPT2 | NUMBER | Amount posted in preferred currency for option 2 | ||
DLCORPNEWSALOPT2 | NUMBER | New salary in preferred currency for option 2 | ||
DLREASONOPT2 | VARCHAR2 | (80) | Reason for option 2 | |
DLEFFECTIVEDTOPT2 | DATE | Effective date for option 2 | ||
DLOPTELIGOPT2 | VARCHAR2 | (80) | Eligible for Option 2 | |
DLFTEFACTOROPT2 | NUMBER | FTE Factor for option 2 | ||
DLNAMESALOPT3 | VARCHAR2 | (240) | Option 3 Name | |
DLCURRENCYOPT3 | VARCHAR2 | (80) | Currency for option 3 | |
DLBASESALARYOPT3 | NUMBER | Base salary for option 3 | ||
DLELIGSALARYOPT3 | NUMBER | Eligible salary for option 3 | ||
DLCWBAMTOPT3 | NUMBER | Amount for option 3 | ||
DLPERCENTOPT3 | NUMBER | Percent for option 3 | ||
DLBASISOPT3 | VARCHAR2 | (30) | Base salary frequency for option 3 | |
DLPAYFACTOROPT3 | NUMBER | Pay annualization factor for option 3 | ||
DLPLANFACTOROPT3 | NUMBER | Plan annualization factor for option 3 | ||
DLFACTOROPT3 | NUMBER | Conversion factor for option 3 | ||
DLADJAMTOPT3 | NUMBER | Adjusted amount for option 3 | ||
DLPREVSALOPT3 | NUMBER | Previous salary for option 3 | ||
DLCHANGEOPT3 | NUMBER | Amount posted for option 3 | ||
DLNEWSALOPT3 | NUMBER | New salary for option 3 | ||
DLXRATEOPT3 | NUMBER | Exchange rate for option 3 | ||
DLCORPBASESALOPT3 | NUMBER | Base salary in preferred currency for option 3 | ||
DLCORPELIGSALOPT3 | NUMBER | Eligible salary in preferred currency for option 3 | ||
DLCORPCWBAMTOPT3 | NUMBER | Amount in preferred currency for option 3 | ||
DLCORPADJAMTOPT3 | NUMBER | Adjusted amount in preferred currency for option 3 | ||
DLCORPPREVSALOPT3 | NUMBER | Previous salary in preferred currency for option 3 | ||
DLCORPCHANGEOPT3 | NUMBER | Amount posted in preferred currency for option 3 | ||
DLCORPNEWSALOPT3 | NUMBER | New salary in preferred currency for option 3 | ||
DLREASONOPT3 | VARCHAR2 | (80) | Reason for option 3 | |
DLEFFECTIVEDTOPT3 | DATE | Effective date for option 3 | ||
DLOPTELIGOPT3 | VARCHAR2 | (80) | Eligible for Option 3 | |
DLFTEFACTOROPT3 | NUMBER | FTE Factor for option 3 | ||
DLNAMESALOPT4 | VARCHAR2 | (240) | Option 4 Name | |
DLCURRENCYOPT4 | VARCHAR2 | (80) | Currency for option 4 | |
DLBASESALARYOPT4 | NUMBER | Base salary for option 4 | ||
DLELIGSALARYOPT4 | NUMBER | Eligible salary for option 4 | ||
DLCWBAMTOPT4 | NUMBER | Amount for option 4 | ||
DLPERCENTOPT4 | NUMBER | Percent for option 4 | ||
DLBASISOPT4 | VARCHAR2 | (30) | Base salary frequency for option 4 | |
DLPAYFACTOROPT4 | NUMBER | Pay annualization factor for option 4 | ||
DLPLANFACTOROPT4 | NUMBER | Plan annualization factor for option 4 | ||
DLFACTOROPT4 | NUMBER | Conversion factor for option 4 | ||
DLADJAMTOPT4 | NUMBER | Adjusted amount for option 4 | ||
DLPREVSALOPT4 | NUMBER | Previous salary for option 4 | ||
DLCHANGEOPT4 | NUMBER | Amount posted for option 4 | ||
DLNEWSALOPT4 | NUMBER | New salary for option 4 | ||
DLXRATEOPT4 | NUMBER | Exchange rate for option 4 | ||
DLCORPBASESALOPT4 | NUMBER | Base salary in preferred currency for option 4 | ||
DLCORPELIGSALOPT4 | NUMBER | Eligible salary in preferred currency for option 4 | ||
DLCORPCWBAMTOPT4 | NUMBER | Amount in preferred currency for option 4 | ||
DLCORPADJAMTOPT4 | NUMBER | Adjusted amount in preferred currency for option 4 | ||
DLCORPPREVSALOPT4 | NUMBER | Previous salary in preferred currency for option 3 | ||
DLCORPCHANGEOPT4 | NUMBER | Amount posted in preferred currency for option 4 | ||
DLCORPNEWSALOPT4 | NUMBER | New salary in preferred currency for option 4 | ||
DLREASONOPT4 | VARCHAR2 | (80) | Reason for option 4 | |
DLEFFECTIVEDTOPT4 | DATE | Effective date for option 4 | ||
DLOPTELIGOPT4 | VARCHAR2 | (80) | Eligible for Option 4 | |
DLFTEFACTOROPT4 | NUMBER | FTE Factor for option 4 | ||
DLNAMENONSALPL | VARCHAR2 | (240) | Non Salary Plan name | |
DLNONSALCURRENCYPL | VARCHAR2 | (80) | Currency | |
DLNONSALELIGSALPL | NUMBER | Eligible salary | ||
DLNONSALCWBAMTPL | NUMBER | Amount | ||
DLNONSALPERCENTSALPL | NUMBER | Percent of eligible salary | ||
DLELEMENTAMTPL | NUMBER | Amount posted | ||
DLNONSALXRATEPL | NUMBER | Exchange rate | ||
DLNONSALCORPELIGSALPL | NUMBER | Eligible salary in preferred currency for option 2 | ||
DLNONSALCORPCWBAMTPL | NUMBER | Non salary amount in preferred currency | ||
DLNONSALCORPAMTPOSTEDPL | NUMBER | Amount posted in preferred currency | ||
DLELEMENTINPUTPL | VARCHAR2 | (80) | Input value | |
DLNONSALEFFDATEPL | DATE | Effective date | ||
DLNONSALELIGPL | VARCHAR2 | (80) | Eligible | |
DLNAMENONSALOPT1 | VARCHAR2 | (240) | Option 1 name | |
DLNONSALCURRENCYOPT1 | VARCHAR2 | (80) | Currency | |
DLNONSALELIGSALOPT1 | NUMBER | Eligible salary | ||
DLNONSALCWBAMTOPT1 | NUMBER | Amount | ||
DLNONSALPERCENTSALOPT1 | NUMBER | Percent | ||
DLELEMENTAMTOPT1 | NUMBER | Amount posted | ||
DLNONSALXRATEOPT1 | NUMBER | Exchange rate | ||
DLNONSALCORPELIGSALOPT1 | NUMBER | Eligible salary in preferred currency | ||
DLNONSALCORPCWBAMTOPT1 | NUMBER | Amount in preferred currency | ||
DLNONSALCORPAMTPOSTEDOPT1 | NUMBER | Amount Posted in preferred currency | ||
DLELEMENTINPUTOPT1 | VARCHAR2 | (80) | Input value | |
DLNONSALEFFDATEOPT1 | DATE | Effective date | ||
DLNONSALELIGOPT1 | VARCHAR2 | (80) | Eligible | |
DLNAMENONSALOPT2 | VARCHAR2 | (240) | Option 2 name | |
DLNONSALCURRENCYOPT2 | VARCHAR2 | (80) | Currency | |
DLNONSALELIGSALOPT2 | NUMBER | Eligible Salary | ||
DLNONSALCWBAMTOPT2 | NUMBER | Amount | ||
DLNONSALPERCENTSALOPT2 | NUMBER | Percent | ||
DLELEMENTAMTOPT2 | NUMBER | Amount posted | ||
DLNONSALXRATEOPT2 | NUMBER | Exchange rate | ||
DLNONSALCORPELIGSALOPT2 | NUMBER | Eligible salary in preferred currency | ||
DLNONSALCORPCWBAMTOPT2 | NUMBER | Amount in preferred currency | ||
DLNONSALCORPAMTPOSTEDOPT2 | NUMBER | Amount posted in preferred currency | ||
DLELEMENTINPUTOPT2 | VARCHAR2 | (80) | Input value | |
DLNONSALEFFDATEOPT2 | DATE | Effective date | ||
DLNONSALELIGOPT2 | VARCHAR2 | (80) | Eligible | |
DLNAMENONSALOPT3 | VARCHAR2 | (240) | Option 3 name | |
DLNONSALCURRENCYOPT3 | VARCHAR2 | (80) | Currency | |
DLNONSALELIGSALOPT3 | NUMBER | Eligible salary | ||
DLNONSALCWBAMTOPT3 | NUMBER | Amount | ||
DLNONSALPERCENTSALOPT3 | NUMBER | Percent | ||
DLELEMENTAMTOPT3 | NUMBER | Amount posted | ||
DLNONSALXRATEOPT3 | NUMBER | Exchange rate | ||
DLNONSALCORPELIGSALOPT3 | NUMBER | Eligible salary in preferred currency | ||
DLNONSALCORPCWBAMTOPT3 | NUMBER | Amount in preferred currency | ||
DLNONSALCORPAMTPOSTEDOPT3 | NUMBER | Amount posted in preferred currency | ||
DLELEMENTINPUTOPT3 | VARCHAR2 | (80) | Input value | |
DLNONSALEFFDATEOPT3 | DATE | Effective date | ||
DLNONSALELIGOPT3 | VARCHAR2 | (80) | Eligible | |
DLNAMENONSALOPT4 | VARCHAR2 | (240) | Option 4 name | |
DLNONSALCURRENCYOPT4 | VARCHAR2 | (80) | Currency | |
DLNONSALELIGSALOPT4 | NUMBER | Eligible salary | ||
DLNONSALCWBAMTOPT4 | NUMBER | Amount | ||
DLNONSALPERCENTSALOPT4 | NUMBER | Percent | ||
DLELEMENTAMTOPT4 | NUMBER | Amount posted | ||
DLNONSALXRATEOPT4 | NUMBER | Exchange rate | ||
DLNONSALCORPELIGSALOPT4 | NUMBER | Eligible salary in preferred currency | ||
DLNONSALCORPCWBAMTOPT4 | NUMBER | Amount in preferred currency | ||
DLNONSALCORPAMTPOSTEDOPT4 | NUMBER | Amount posted in preferred currency | ||
DLELEMENTINPUTOPT4 | VARCHAR2 | (80) | Input value | |
DLNONSALEFFDATEOPT4 | DATE | Effective date | ||
DLNONSALELIGOPT4 | VARCHAR2 | (80) | Eligible | |
DLNAMENONMONPL | VARCHAR2 | (240) | Non Monetary Plan name | |
DLNONMONUOMPL | VARCHAR2 | (30) | Non monetary unit of measure | |
DLNONMONCWBAMTPL | NUMBER | Non monetary amount | ||
DLNONMONAMTPOSTEDPL | NUMBER | Amount posted | ||
DLNONMONELINPUTPL | VARCHAR2 | (80) | Input value | |
DLNONMONEFFDATEPL | DATE | Effective date | ||
DLNONMONELIGPL | VARCHAR2 | (80) | Eligible | |
DLNAMENONMONOPT1 | VARCHAR2 | (240) | Option 1 name | |
DLNONMONUOMOPT1 | VARCHAR2 | (30) | Unit of measure | |
DLNONMONCWBAMTOPT1 | NUMBER | Amount | ||
DLNONMONAMTPOSTEDOPT1 | NUMBER | Amount posted | ||
DLNONMONELINPUTOPT1 | VARCHAR2 | (80) | Input value | |
DLNONMONEFFDATEOPT1 | DATE | Effective date | ||
DLNONMONELIGOPT1 | VARCHAR2 | (80) | Eligible | |
DLNAMENONMONOPT2 | VARCHAR2 | (240) | Option 2 name | |
DLNONMONUOMOPT2 | VARCHAR2 | (30) | Unit of measure | |
DLNONMONCWBAMTOPT2 | NUMBER | Amount | ||
DLNONMONAMTPOSTEDOPT2 | NUMBER | Amount posted | ||
DLNONMONELINPUTOPT2 | VARCHAR2 | (80) | Input value | |
DLNONMONEFFDATEOPT2 | DATE | Effective date | ||
DLNONMONELIGOPT2 | VARCHAR2 | (80) | Eligible | |
DLNAMENONMONOPT3 | VARCHAR2 | (240) | Option 3 name | |
DLNONMONUOMOPT3 | VARCHAR2 | (30) | Unit of measure | |
DLNONMONCWBAMTOPT3 | NUMBER | Amount | ||
DLNONMONAMTPOSTEDOPT3 | NUMBER | Amount posted | ||
DLNONMONELINPUTOPT3 | VARCHAR2 | (80) | Input value | |
DLNONMONEFFDATEOPT3 | DATE | Effective date | ||
DLNONMONELIGOPT3 | VARCHAR2 | (80) | Eligible | |
DLNAMENONMONOPT4 | VARCHAR2 | (240) | Option 4 name | |
DLNONMONUOMOPT4 | VARCHAR2 | (30) | Unit of measure | |
DLNONMONCWBAMTOPT4 | NUMBER | Amount | ||
DLNONMONAMTPOSTEDOPT4 | NUMBER | Amount posted | ||
DLNONMONELINPUTOPT4 | VARCHAR2 | (80) | Input value | |
DLNONMONEFFDATEOPT4 | DATE | Effective date | ||
DLNONMONELIGOPT4 | VARCHAR2 | (80) | Eligible | |
DLNAMERECURPL | VARCHAR2 | (240) | Plan name | |
DLRECURCURRENCYPL | VARCHAR2 | (80) | Currency | |
DLRECURELIGSALPL | NUMBER | Eligible Salary | ||
DLRECURCWBAMTPL | NUMBER | Amount | ||
DLRECURPERCENTSALPL | NUMBER | Percent | ||
DLRPREVELEMENTAMTPL | NUMBER | Previous element screen entry value | ||
DLRELEMENTAMTPL | NUMBER | Amount | ||
DLRECURXRATEPL | NUMBER | Exchange rate | ||
DLRECURCORPELIGSALPL | NUMBER | Eligible salary | ||
DLRECURCORPCWBAMTPL | NUMBER | Amount in preferred currency | ||
DLCORPRPREVELEMENTAMTPL | NUMBER | Previous element amount in preferred currency | ||
DLRECURCORPAMTPOSTEDPL | NUMBER | Amount posted in preferred currency | ||
DLRELEMENTINPUTPL | VARCHAR2 | (80) | Input value | |
DLRECUREFFDATEPL | DATE | Effective date | ||
DLRECURELIGPL | VARCHAR2 | (80) | Eligible | |
DLNAMERECUROPT1 | VARCHAR2 | (240) | Option 1 name | |
DLRECURCURRENCYOPT1 | VARCHAR2 | (80) | Currency | |
DLRECURELIGSALOPT1 | NUMBER | Eligible salary | ||
DLRECURCWBAMTOPT1 | NUMBER | Amount | ||
DLRECURPERCENTSALOPT1 | NUMBER | Percent | ||
DLRPREVELEMENTAMTOPT1 | NUMBER | Previous element amount | ||
DLRELEMENTAMTOPT1 | NUMBER | Amount | ||
DLRECURXRATEOPT1 | NUMBER | Exchange rate | ||
DLRECURCORPELIGSALOPT1 | NUMBER | Eligible salary in preferred currency | ||
DLRECURCORPCWBAMTOPT1 | NUMBER | Amount in preferred currency | ||
DLCORPRPREVELEMENTAMTOPT1 | NUMBER | Previous element amount in preferred currency | ||
DLRECURCORPAMTPOSTEDOPT1 | NUMBER | Amount posted in preferred currency | ||
DLRELEMENTINPUTOPT1 | VARCHAR2 | (80) | Input value | |
DLRECUREFFDATEOPT1 | DATE | Effective date | ||
DLRECURELIGOPT1 | VARCHAR2 | (80) | Eligible | |
DLNAMERECUROPT2 | VARCHAR2 | (240) | Option 2 name | |
DLRECURCURRENCYOPT2 | VARCHAR2 | (80) | Currency | |
DLRECURELIGSALOPT2 | NUMBER | Eligible salary | ||
DLRECURCWBAMTOPT2 | NUMBER | Amount | ||
DLRECURPERCENTSALOPT2 | NUMBER | Percent | ||
DLRPREVELEMENTAMTOPT2 | NUMBER | Previous element amount | ||
DLRELEMENTAMTOPT2 | NUMBER | Amount | ||
DLRECURXRATEOPT2 | NUMBER | Exchange rate | ||
DLRECURCORPELIGSALOPT2 | NUMBER | Eligible salary in preferred currency | ||
DLRECURCORPCWBAMTOPT2 | NUMBER | Amount in preferred currency | ||
DLCORPRPREVELEMENTAMTOPT2 | NUMBER | Previous element amount in preferred currency | ||
DLRECURCORPAMTPOSTEDOPT2 | NUMBER | Amount posted in preferred currency | ||
DLRELEMENTINPUTOPT2 | VARCHAR2 | (80) | Input value | |
DLRECUREFFDATEOPT2 | DATE | Effective date | ||
DLRECURELIGOPT2 | VARCHAR2 | (80) | Eligible | |
DLNAMERECUROPT3 | VARCHAR2 | (240) | Option 3 name | |
DLRECURCURRENCYOPT3 | VARCHAR2 | (80) | Currency | |
DLRECURELIGSALOPT3 | NUMBER | Eligible salary | ||
DLRECURCWBAMTOPT3 | NUMBER | Amount | ||
DLRECURPERCENTSALOPT3 | NUMBER | Percent | ||
DLRPREVELEMENTAMTOPT3 | NUMBER | Previous element amount | ||
DLRELEMENTAMTOPT3 | NUMBER | Amount | ||
DLRECURXRATEOPT3 | NUMBER | Exchange rate | ||
DLRECURCORPELIGSALOPT3 | NUMBER | Eligible salary in preferred currency | ||
DLRECURCORPCWBAMTOPT3 | NUMBER | Amount in preferred currency | ||
DLCORPRPREVELEMENTAMTOPT3 | NUMBER | Previous element amount | ||
DLRECURCORPAMTPOSTEDOPT3 | NUMBER | Amount posted in preferred currency | ||
DLRELEMENTINPUTOPT3 | VARCHAR2 | (80) | Input value | |
DLRECUREFFDATEOPT3 | DATE | Effective date | ||
DLRECURELIGOPT3 | VARCHAR2 | (80) | Eligible | |
DLNAMERECUROPT4 | VARCHAR2 | (240) | Option 4 name | |
DLRECURCURRENCYOPT4 | VARCHAR2 | (80) | Currency | |
DLRECURELIGSALOPT4 | NUMBER | Eligible salary | ||
DLRECURCWBAMTOPT4 | NUMBER | Amount | ||
DLRECURPERCENTSALOPT4 | NUMBER | Percent | ||
DLRPREVELEMENTAMTOPT4 | NUMBER | Previous element amount | ||
DLRELEMENTAMTOPT4 | NUMBER | Amount | ||
DLRECURXRATEOPT4 | NUMBER | Exchange rate | ||
DLRECURCORPELIGSALOPT4 | NUMBER | Eligible salary in preferred currency | ||
DLRECURCORPCWBAMTOPT4 | NUMBER | Amount in preferred currency | ||
DLCORPRPREVELEMENTAMTOPT4 | NUMBER | Previous element amount in preferred currency | ||
DLRECURCORPAMTPOSTEDOPT4 | NUMBER | Amount posted in preferred currency | ||
DLRELEMENTINPUTOPT4 | VARCHAR2 | (80) | Input value | |
DLRECUREFFDATEOPT4 | DATE | Effective date | ||
DLRECURELIGOPT4 | VARCHAR2 | (80) | Eligible | |
DLCWBRATING | VARCHAR2 | (30) | Rating | |
DLPOSTEDRATING | VARCHAR2 | (30) | Posted rating | |
DLRATINGTYPE | VARCHAR2 | (80) | Rating type | |
DLRATINGDATE | DATE | Rating date | ||
DLASSFLAG | VARCHAR2 | (30) | Assignment changed flag | |
DLBEFOREJOB | VARCHAR2 | (700) | Before Job | |
DLAFTERJOB | VARCHAR2 | (700) | After Job | |
DLJOB | VARCHAR2 | (700) | Job | |
DLBEFOREPOSITION | VARCHAR2 | (240) | Before Position | |
DLAFTERPOSITION | VARCHAR2 | (240) | After Position | |
DLPOSITION | VARCHAR2 | (240) | Position | |
DLBEFOREGRADE | VARCHAR2 | (240) | Before grade | |
DLAFTERGRADE | VARCHAR2 | (240) | After grade | |
DLGRADE | VARCHAR2 | (240) | Grade | |
DLBEFOREGROUP | VARCHAR2 | (240) | Before group | |
DLAFTERGROUP | VARCHAR2 | (240) | After group | |
DLGRUP | VARCHAR2 | (240) | Group | |
DLCHANGEREASON | VARCHAR2 | (80) | Change reason | |
DLPENDGWORKFLOW | VARCHAR2 | (30) | Pending workflow | |
DLBEFOREFLEX1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX16 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX16 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX16 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX17 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX17 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX17 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX18 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX18 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX18 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX19 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX19 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX19 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX20 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX20 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX20 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX21 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX21 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX21 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX22 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX22 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX22 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX23 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX23 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX23 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX24 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX24 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX24 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX25 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX25 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX25 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX26 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX26 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX26 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX27 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX27 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX27 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX28 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX28 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX28 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX29 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX29 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX29 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLBEFOREFLEX30 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLAFTERFLEX30 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLFLEX30 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DLASGNEFFECTIVEDATE | DATE | Effective date | ||
DLOPTION1ID | NUMBER | Group option in plan id | ||
DLOPTION2ID | NUMBER | Group option in plan id | ||
DLOPTION3ID | NUMBER | Group option in plan id | ||
DLOPTION4ID | NUMBER | Group option in plan id | ||
DLBENEFITACTIONID | NUMBER | (15) | Benefit action Id. Foreign key to BEN_BENEFIT_ACTIONS | |
DLPROCESSDATE | DATE | Process date | ||
DLGROUPPERINLERID | NUMBER | Group Per in ler Id | ||
DLPERSONID | NUMBER | (15) | Person Id. Foreign key to PER_ALL_PEOPLE_F | |
DLREQUESTID | NUMBER | (15) | Request Id. Foreign key to FND_CONCURRENT_REQUESTS |
Cut, paste (and edit) the following text to query this object:
SELECT DLSECUREDNAMEPR
, DLNUMPR
, DLSTATUSPR
, DLMESSAGEPR
, DLCOUNTRYPR
, DLBGNAMEPR
, DLLOCALPLANPR
, DLELIGPR
, DLEVTPR
, DLNAMESALPL
, DLCURRENCYPL
, DLBASESALARYPL
, DLELIGSALARYPL
, DLCWBAMTPL
, DLPERCENTPL
, DLBASISPL
, DLPAYFACTORPL
, DLPLANFACTORPL
, DLFACTORPL
, DLADJAMTPL
, DLPREVSALPL
, DLCHANGEPL
, DLNEWSALPL
, DLXRATEPL
, DLCORPBASESALPL
, DLCORPELIGSALPL
, DLCORPCWBAMTPL
, DLCORPADJAMTPL
, DLCORPPREVSALPL
, DLCORPCHANGEPL
, DLCORPNEWSALPL
, DLREASONPL
, DLEFFECTIVEDTPL
, DLOPTELIGPL
, DLFTEFACTORPL
, DLNAMESALOPT1
, DLCURRENCYOPT1
, DLBASESALARYOPT1
, DLELIGSALARYOPT1
, DLCWBAMTOPT1
, DLPERCENTOPT1
, DLBASISOPT1
, DLPAYFACTOROPT1
, DLPLANFACTOROPT1
, DLFACTOROPT1
, DLADJAMTOPT1
, DLPREVSALOPT1
, DLCHANGEOPT1
, DLNEWSALOPT1
, DLXRATEOPT1
, DLCORPBASESALOPT1
, DLCORPELIGSALOPT1
, DLCORPCWBAMTOPT1
, DLCORPADJAMTOPT1
, DLCORPPREVSALOPT1
, DLCORPCHANGEOPT1
, DLCORPNEWSALOPT1
, DLREASONOPT1
, DLEFFECTIVEDTOPT1
, DLOPTELIGOPT1
, DLFTEFACTOROPT1
, DLNAMESALOPT2
, DLCURRENCYOPT2
, DLBASESALARYOPT2
, DLELIGSALARYOPT2
, DLCWBAMTOPT2
, DLPERCENTOPT2
, DLBASISOPT2
, DLPAYFACTOROPT2
, DLPLANFACTOROPT2
, DLFACTOROPT2
, DLADJAMTOPT2
, DLPREVSALOPT2
, DLCHANGEOPT2
, DLNEWSALOPT2
, DLXRATEOPT2
, DLCORPBASESALOPT2
, DLCORPELIGSALOPT2
, DLCORPCWBAMTOPT2
, DLCORPADJAMTOPT2
, DLCORPPREVSALOPT2
, DLCORPCHANGEOPT2
, DLCORPNEWSALOPT2
, DLREASONOPT2
, DLEFFECTIVEDTOPT2
, DLOPTELIGOPT2
, DLFTEFACTOROPT2
, DLNAMESALOPT3
, DLCURRENCYOPT3
, DLBASESALARYOPT3
, DLELIGSALARYOPT3
, DLCWBAMTOPT3
, DLPERCENTOPT3
, DLBASISOPT3
, DLPAYFACTOROPT3
, DLPLANFACTOROPT3
, DLFACTOROPT3
, DLADJAMTOPT3
, DLPREVSALOPT3
, DLCHANGEOPT3
, DLNEWSALOPT3
, DLXRATEOPT3
, DLCORPBASESALOPT3
, DLCORPELIGSALOPT3
, DLCORPCWBAMTOPT3
, DLCORPADJAMTOPT3
, DLCORPPREVSALOPT3
, DLCORPCHANGEOPT3
, DLCORPNEWSALOPT3
, DLREASONOPT3
, DLEFFECTIVEDTOPT3
, DLOPTELIGOPT3
, DLFTEFACTOROPT3
, DLNAMESALOPT4
, DLCURRENCYOPT4
, DLBASESALARYOPT4
, DLELIGSALARYOPT4
, DLCWBAMTOPT4
, DLPERCENTOPT4
, DLBASISOPT4
, DLPAYFACTOROPT4
, DLPLANFACTOROPT4
, DLFACTOROPT4
, DLADJAMTOPT4
, DLPREVSALOPT4
, DLCHANGEOPT4
, DLNEWSALOPT4
, DLXRATEOPT4
, DLCORPBASESALOPT4
, DLCORPELIGSALOPT4
, DLCORPCWBAMTOPT4
, DLCORPADJAMTOPT4
, DLCORPPREVSALOPT4
, DLCORPCHANGEOPT4
, DLCORPNEWSALOPT4
, DLREASONOPT4
, DLEFFECTIVEDTOPT4
, DLOPTELIGOPT4
, DLFTEFACTOROPT4
, DLNAMENONSALPL
, DLNONSALCURRENCYPL
, DLNONSALELIGSALPL
, DLNONSALCWBAMTPL
, DLNONSALPERCENTSALPL
, DLELEMENTAMTPL
, DLNONSALXRATEPL
, DLNONSALCORPELIGSALPL
, DLNONSALCORPCWBAMTPL
, DLNONSALCORPAMTPOSTEDPL
, DLELEMENTINPUTPL
, DLNONSALEFFDATEPL
, DLNONSALELIGPL
, DLNAMENONSALOPT1
, DLNONSALCURRENCYOPT1
, DLNONSALELIGSALOPT1
, DLNONSALCWBAMTOPT1
, DLNONSALPERCENTSALOPT1
, DLELEMENTAMTOPT1
, DLNONSALXRATEOPT1
, DLNONSALCORPELIGSALOPT1
, DLNONSALCORPCWBAMTOPT1
, DLNONSALCORPAMTPOSTEDOPT1
, DLELEMENTINPUTOPT1
, DLNONSALEFFDATEOPT1
, DLNONSALELIGOPT1
, DLNAMENONSALOPT2
, DLNONSALCURRENCYOPT2
, DLNONSALELIGSALOPT2
, DLNONSALCWBAMTOPT2
, DLNONSALPERCENTSALOPT2
, DLELEMENTAMTOPT2
, DLNONSALXRATEOPT2
, DLNONSALCORPELIGSALOPT2
, DLNONSALCORPCWBAMTOPT2
, DLNONSALCORPAMTPOSTEDOPT2
, DLELEMENTINPUTOPT2
, DLNONSALEFFDATEOPT2
, DLNONSALELIGOPT2
, DLNAMENONSALOPT3
, DLNONSALCURRENCYOPT3
, DLNONSALELIGSALOPT3
, DLNONSALCWBAMTOPT3
, DLNONSALPERCENTSALOPT3
, DLELEMENTAMTOPT3
, DLNONSALXRATEOPT3
, DLNONSALCORPELIGSALOPT3
, DLNONSALCORPCWBAMTOPT3
, DLNONSALCORPAMTPOSTEDOPT3
, DLELEMENTINPUTOPT3
, DLNONSALEFFDATEOPT3
, DLNONSALELIGOPT3
, DLNAMENONSALOPT4
, DLNONSALCURRENCYOPT4
, DLNONSALELIGSALOPT4
, DLNONSALCWBAMTOPT4
, DLNONSALPERCENTSALOPT4
, DLELEMENTAMTOPT4
, DLNONSALXRATEOPT4
, DLNONSALCORPELIGSALOPT4
, DLNONSALCORPCWBAMTOPT4
, DLNONSALCORPAMTPOSTEDOPT4
, DLELEMENTINPUTOPT4
, DLNONSALEFFDATEOPT4
, DLNONSALELIGOPT4
, DLNAMENONMONPL
, DLNONMONUOMPL
, DLNONMONCWBAMTPL
, DLNONMONAMTPOSTEDPL
, DLNONMONELINPUTPL
, DLNONMONEFFDATEPL
, DLNONMONELIGPL
, DLNAMENONMONOPT1
, DLNONMONUOMOPT1
, DLNONMONCWBAMTOPT1
, DLNONMONAMTPOSTEDOPT1
, DLNONMONELINPUTOPT1
, DLNONMONEFFDATEOPT1
, DLNONMONELIGOPT1
, DLNAMENONMONOPT2
, DLNONMONUOMOPT2
, DLNONMONCWBAMTOPT2
, DLNONMONAMTPOSTEDOPT2
, DLNONMONELINPUTOPT2
, DLNONMONEFFDATEOPT2
, DLNONMONELIGOPT2
, DLNAMENONMONOPT3
, DLNONMONUOMOPT3
, DLNONMONCWBAMTOPT3
, DLNONMONAMTPOSTEDOPT3
, DLNONMONELINPUTOPT3
, DLNONMONEFFDATEOPT3
, DLNONMONELIGOPT3
, DLNAMENONMONOPT4
, DLNONMONUOMOPT4
, DLNONMONCWBAMTOPT4
, DLNONMONAMTPOSTEDOPT4
, DLNONMONELINPUTOPT4
, DLNONMONEFFDATEOPT4
, DLNONMONELIGOPT4
, DLNAMERECURPL
, DLRECURCURRENCYPL
, DLRECURELIGSALPL
, DLRECURCWBAMTPL
, DLRECURPERCENTSALPL
, DLRPREVELEMENTAMTPL
, DLRELEMENTAMTPL
, DLRECURXRATEPL
, DLRECURCORPELIGSALPL
, DLRECURCORPCWBAMTPL
, DLCORPRPREVELEMENTAMTPL
, DLRECURCORPAMTPOSTEDPL
, DLRELEMENTINPUTPL
, DLRECUREFFDATEPL
, DLRECURELIGPL
, DLNAMERECUROPT1
, DLRECURCURRENCYOPT1
, DLRECURELIGSALOPT1
, DLRECURCWBAMTOPT1
, DLRECURPERCENTSALOPT1
, DLRPREVELEMENTAMTOPT1
, DLRELEMENTAMTOPT1
, DLRECURXRATEOPT1
, DLRECURCORPELIGSALOPT1
, DLRECURCORPCWBAMTOPT1
, DLCORPRPREVELEMENTAMTOPT1
, DLRECURCORPAMTPOSTEDOPT1
, DLRELEMENTINPUTOPT1
, DLRECUREFFDATEOPT1
, DLRECURELIGOPT1
, DLNAMERECUROPT2
, DLRECURCURRENCYOPT2
, DLRECURELIGSALOPT2
, DLRECURCWBAMTOPT2
, DLRECURPERCENTSALOPT2
, DLRPREVELEMENTAMTOPT2
, DLRELEMENTAMTOPT2
, DLRECURXRATEOPT2
, DLRECURCORPELIGSALOPT2
, DLRECURCORPCWBAMTOPT2
, DLCORPRPREVELEMENTAMTOPT2
, DLRECURCORPAMTPOSTEDOPT2
, DLRELEMENTINPUTOPT2
, DLRECUREFFDATEOPT2
, DLRECURELIGOPT2
, DLNAMERECUROPT3
, DLRECURCURRENCYOPT3
, DLRECURELIGSALOPT3
, DLRECURCWBAMTOPT3
, DLRECURPERCENTSALOPT3
, DLRPREVELEMENTAMTOPT3
, DLRELEMENTAMTOPT3
, DLRECURXRATEOPT3
, DLRECURCORPELIGSALOPT3
, DLRECURCORPCWBAMTOPT3
, DLCORPRPREVELEMENTAMTOPT3
, DLRECURCORPAMTPOSTEDOPT3
, DLRELEMENTINPUTOPT3
, DLRECUREFFDATEOPT3
, DLRECURELIGOPT3
, DLNAMERECUROPT4
, DLRECURCURRENCYOPT4
, DLRECURELIGSALOPT4
, DLRECURCWBAMTOPT4
, DLRECURPERCENTSALOPT4
, DLRPREVELEMENTAMTOPT4
, DLRELEMENTAMTOPT4
, DLRECURXRATEOPT4
, DLRECURCORPELIGSALOPT4
, DLRECURCORPCWBAMTOPT4
, DLCORPRPREVELEMENTAMTOPT4
, DLRECURCORPAMTPOSTEDOPT4
, DLRELEMENTINPUTOPT4
, DLRECUREFFDATEOPT4
, DLRECURELIGOPT4
, DLCWBRATING
, DLPOSTEDRATING
, DLRATINGTYPE
, DLRATINGDATE
, DLASSFLAG
, DLBEFOREJOB
, DLAFTERJOB
, DLJOB
, DLBEFOREPOSITION
, DLAFTERPOSITION
, DLPOSITION
, DLBEFOREGRADE
, DLAFTERGRADE
, DLGRADE
, DLBEFOREGROUP
, DLAFTERGROUP
, DLGRUP
, DLCHANGEREASON
, DLPENDGWORKFLOW
, DLBEFOREFLEX1
, DLAFTERFLEX1
, DLFLEX1
, DLBEFOREFLEX2
, DLAFTERFLEX2
, DLFLEX2
, DLBEFOREFLEX3
, DLAFTERFLEX3
, DLFLEX3
, DLBEFOREFLEX4
, DLAFTERFLEX4
, DLFLEX4
, DLBEFOREFLEX5
, DLAFTERFLEX5
, DLFLEX5
, DLBEFOREFLEX6
, DLAFTERFLEX6
, DLFLEX6
, DLBEFOREFLEX7
, DLAFTERFLEX7
, DLFLEX7
, DLBEFOREFLEX8
, DLAFTERFLEX8
, DLFLEX8
, DLBEFOREFLEX9
, DLAFTERFLEX9
, DLFLEX9
, DLBEFOREFLEX10
, DLAFTERFLEX10
, DLFLEX10
, DLBEFOREFLEX11
, DLAFTERFLEX11
, DLFLEX11
, DLBEFOREFLEX12
, DLAFTERFLEX12
, DLFLEX12
, DLBEFOREFLEX13
, DLAFTERFLEX13
, DLFLEX13
, DLBEFOREFLEX14
, DLAFTERFLEX14
, DLFLEX14
, DLBEFOREFLEX15
, DLAFTERFLEX15
, DLFLEX15
, DLBEFOREFLEX16
, DLAFTERFLEX16
, DLFLEX16
, DLBEFOREFLEX17
, DLAFTERFLEX17
, DLFLEX17
, DLBEFOREFLEX18
, DLAFTERFLEX18
, DLFLEX18
, DLBEFOREFLEX19
, DLAFTERFLEX19
, DLFLEX19
, DLBEFOREFLEX20
, DLAFTERFLEX20
, DLFLEX20
, DLBEFOREFLEX21
, DLAFTERFLEX21
, DLFLEX21
, DLBEFOREFLEX22
, DLAFTERFLEX22
, DLFLEX22
, DLBEFOREFLEX23
, DLAFTERFLEX23
, DLFLEX23
, DLBEFOREFLEX24
, DLAFTERFLEX24
, DLFLEX24
, DLBEFOREFLEX25
, DLAFTERFLEX25
, DLFLEX25
, DLBEFOREFLEX26
, DLAFTERFLEX26
, DLFLEX26
, DLBEFOREFLEX27
, DLAFTERFLEX27
, DLFLEX27
, DLBEFOREFLEX28
, DLAFTERFLEX28
, DLFLEX28
, DLBEFOREFLEX29
, DLAFTERFLEX29
, DLFLEX29
, DLBEFOREFLEX30
, DLAFTERFLEX30
, DLFLEX30
, DLASGNEFFECTIVEDATE
, DLOPTION1ID
, DLOPTION2ID
, DLOPTION3ID
, DLOPTION4ID
, DLBENEFITACTIONID
, DLPROCESSDATE
, DLGROUPPERINLERID
, DLPERSONID
, DLREQUESTID
FROM APPS.BEN_CWB_PP_ENH_AUDIT_DN_V;
|
|
|