EMPLIDPrompt Table: FPAEMPLOY_SRND2
EMPL_RCDDefault Value: 1
FPAEMPLOY_SRND(SQL View) |
Index Back |
|---|---|
Emp Rec Nb in Assignment tableThis view retrieves the employee record numbers for all the employees with data in the assignment table. It is used by the French Public Sector functionalities. |
| SELECT DISTINCT EMPLID , EMPL_RCD FROM PS_FPAEEPOST_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: FPAEMPLOY_SRND2 |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Default Value: 1 |