EMPLIDSAD_BR_BPV_SEQ_NLDPrompt Table: %EDITTABLE6
Prompt Table: %EDITTABLE2
SSR_BR_BPV_VW(SQL View) |
Index Back |
|---|---|
View to display on BPV sec pagView to display Internal Contract and Hegis code on BPV sec page |
| SELECT EMPLID , SAD_BR_BPV_SEQ_NLD , SAD_INT_CONTR_NLD , HEGIS_CODE FROM PS_SAD_BPV_STC_NLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SAD_BR_BPV_SEQ_NLD |
Number(2,0) | SMALLINT NOT NULL | BPV sequence number |
| 3 | SAD_INT_CONTR_NLD | Character(16) | VARCHAR2(16) NOT NULL |
Internal contract
Prompt Table: %EDITTABLE6 |
| 4 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL |
HEGIS Code
Prompt Table: %EDITTABLE2 |