LBR_ROSTER_IDEFFDTDefault Value: %date
SEQ_NUMPrompt Table: HR_LBR_TIE_VW
Y/N Table Edit
Default Value: N
HR_ROST_TIEBRK(SQL Table) |
Index Back |
|---|---|
HR - Roster Tiebreaker types.Defines the Tiebreaker 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 | TIEBREAKER_ID | Character(11) | VARCHAR2(11) NOT NULL |
Tie Breaker ID
Prompt Table: HR_LBR_TIE_VW |
| 5 | LBR_DESC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Descending Order?
Y/N Table Edit Default Value: N |