PAY_END_DTPrompt Table: PAY_OL_DT_US_VW
EMPLIDEMPL_RCDOPRIDZZ_PAY_OL_SRCH(SQL View) |
Index Back |
|---|---|
Security for US Online ChkThis is the search record presented to the user to access online check data entry panel for USA. This search record has peoplecode that finds out Company/Paygroup/PayEndDate/Page for the employee entered and does a transfer to the online cheque data entry panel search record PAY_OL_PG_US_VW. |
| SELECT A.PAY_END_DT ,A.EMPLID ,A.EMPL_RCD ,B.OPRID ,A.COMPANY ,A.PAYGROUP FROM PS_PAY_OL_US_SRCH A ,PS_PERS_SRCH_GBL B WHERE A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_END_DT |
Date(10) | DATE NOT NULL |
Pay Period End Date
Prompt Table: PAY_OL_DT_US_VW |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 6 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |