EMPLIDPrompt Table: PEOPLE_SRCH
RELATIONSHIP_NBRPrompt Table: RELATIONSHIPS
EFFDTDefault Value: %date
SCC_LETTER_CDPrompt Table: SCC_STN_LTR_TBL
REL_MULT_RECPNT(SQL Table) |
Index Back |
|---|---|
Relationships Mult RecipientsREL_MULT_RECPNT contains Letter Code(s) that will be used to determine if an copy of a communication is to be sent for the Related ID specified on the RELATIONSHIPS record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | RELATIONSHIP_NBR |
Number(2,0) | SMALLINT NOT NULL |
Relationship Nbr
Prompt Table: RELATIONSHIPS |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SCC_LETTER_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table: SCC_STN_LTR_TBL |