Name |
Descriptive Flex |
Display |
Insert |
Update |
Default Type |
Default Value |
Shared Name |
ATTRIBUTE1 |
$SRS$.GHRNFCPOSIEXT |
N |
N |
N | P | PER_BUSINESS_GROUP_ID | |
ATTRIBUTE13 |
$SRS$.GHRNFCPOSIEXT |
Y |
Y |
Y | S | select sysdate from dual | Effective Date |
ATTRIBUTE14 |
$SRS$.GHRNFCPOSIEXT |
Y |
Y |
Y | S | SELECt hrl.lookup_code FROM HR_LOOKUPS HRL WHERE HRL.LOOKUP_TYPE = 'GHR_US_NFC_AGENCY_CODE' AND HRL.ENABLED_FLAG = 'Y' | Agency Code |
ATTRIBUTE15 |
$SRS$.GHRNFCPOSIEXT |
Y |
Y |
Y | | | POI |
ATTRIBUTE18 |
$SRS$.GHRNFCPOSIEXT |
Y |
Y |
Y | | SELECt hrl.lookup_code FROM HR_LOOKUPS HRL WHERE hrl.lookup_type='GHR_US_USER_ID' AND HRL.ENABLED_FLAG = 'Y' | User ID |
ATTRIBUTE2 |
$SRS$.GHRNFCPOSIEXT |
N |
N |
N | | | |
ATTRIBUTE21 |
$SRS$.GHRNFCPOSIEXT |
Y |
Y |
Y | S | SELECt substr(hrl.lookup_code,0,2) FROM HR_LOOKUPS HRL WHERE hrl.lookup_type='GHR_US_AGENCY_CODE' AND hrl.application_id=800 AND HRL.ENABLED_FLAG = 'Y' | Department_code |
ATTRIBUTE4 |
$SRS$.GHRNFCPOSIEXT |
Y |
Y |
Y | | | JCL Extract Name |