Product: | GHR - US Federal Human Resources |
---|---|
User Name: | NFC Personnel Data Outbound Interface |
Description: | NFC Position Outbound Interface |
Enabled: | Yes |
Execution Method: | PL/SQL Stored Procedure |
Argument Method: | Standard |
User Name: | GHR NFC PERSONNEL ACTION |
---|---|
Description: | Executable for Personnel Action File |
Execution Filename: | ghr_us_nfc_extracts.nfc_extract_process |
Subroutine Name: |
Name | Descriptive Flex | Display | Insert | Update | Default Type | Default Value | Shared Name |
---|---|---|---|---|---|---|---|
ATTRIBUTE1 | $SRS$.GHRNFCRPAEXT | N | N | N | P | PER_BUSINESS_GROUP_ID | Business_group_Id |
ATTRIBUTE13 | $SRS$.GHRNFCRPAEXT | Y | Y | Y | S | select sysdate from dual | Effective Date |
ATTRIBUTE14 | $SRS$.GHRNFCRPAEXT | 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$.GHRNFCRPAEXT | Y | Y | Y | POI | ||
ATTRIBUTE18 | $SRS$.GHRNFCRPAEXT | Y | Y | Y | S | 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$.GHRNFCRPAEXT | N | N | N | |||
ATTRIBUTE4 | $SRS$.GHRNFCRPAEXT | Y | Y | Y | JCL Name | ||
ATTRIBUTE5 | $SRS$.GHRNFCRPAEXT | N | N | N | |||
ATTRIBUTE6 | $SRS$.GHRNFCRPAEXT | N | N | N | |||
ATTRIBUTE7 | $SRS$.GHRNFCRPAEXT | N | N | N | S | select meaning from hr_lookups where LOOKUP_TYPE = 'PQP_NFC_TRANSMISSION_TYPE' and lookup_code ='CHG' |
|
|
|