EMPLIDPrompt Table: PERSON
EMPL_RCDPrompt Table: PER_ORG_ASGN_VW
TERM_RQST_SRCH(SQL View) |
Index Back |
|---|---|
Final Check Search ViewThis view is used as a standard search record for the Final Check Request panel. |
| SELECT A.EMPLID, A.EMPL_RCD, B.NAME FROM PS_TERM_RQST A, PS_PERSONAL_DTA_VW B WHERE A.EMPLID = B.EMPLID AND A.EFFDT = (SELECT MAX(EFFDT) FROM PS_TERM_RQST WHERE A.EMPLID = EMPLID AND A.EMPL_RCD = EMPL_RCD) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN_VW |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |