Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'BUDGET_TYPE' AND VALUE = BUDGET_TYPE |
NA |
NO |
REPORTING VIEW |
POSITION_DEFINITION |
BUDGET_TYPE_DESC |
NO |
|
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'CONTRACT_LENGTH' AND VALUE = CONTRACT_LENGTH |
NA |
NO |
REPORTING VIEW |
FACULTY_APPOINTMENT_HISTORY |
CONTRACT_LENGTH_DESC |
NO |
|
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TICKLER_STATUS' AND VALUE = RECENT_TICKLER_STATUS |
NA |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
RECENT_TICKLER_STATUS_DESC |
NO |
|