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