EMPLIDEFFDTDefault Value: %date
PRIMARY_JOB_APPBN=Primary Job Application
PA=Pension Administration
PRIM_JOBS_SRCH(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , A.EFFDT , A.PRIMARY_JOB_APP FROM PS_PRIMARY_JOBS A WHERE A.EMPLID = EMPLID AND A.EFFDT = EFFDT AND A.PRIMARY_JOB_APP = 'BN' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | PRIMARY_JOB_APP |
Character(2) | VARCHAR2(2) NOT NULL |
Denotes the PeopleSoft Application to which this row applies.
BN=Primary Job Application PA=Pension Administration |