LBR_ROSTER_IDEFFDTDefault Value: %date
SEQ_NUMPrompt Table: HR_LBR_SNR_VW
HR_ROST_SNR_DT(SQL Table) |
Index Back |
|---|---|
HR - Roster Seniority Dates.Defines the Seniority Date Types attached to a given Layoff/ Recall Roster. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LBR_ROSTER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Roster ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | SENIORITY_DATE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Seniority Date ID
Prompt Table: HR_LBR_SNR_VW |