EMPLIDPrompt Table: HCR_PERSON_I
EFFDTDefault Value: %date
SCC_CORSP_NLD_I(SQL View) |
Index Back |
|---|---|
CS NLD Corr Interface ViewInterface View based on SSR_CORRSPN_NLD ,Used by Constituent Management Service |
| SELECT EMPLID , EFFDT , SSR_CORRSPN_NR_NLD FROM PS_SSR_CORRSPN_NLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HCR_PERSON_I |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | SSR_CORRSPN_NR_NLD | Character(12) | VARCHAR2(12) NOT NULL | Correspondance Number IBG |