| 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 |
[Home] [Help]