EMPLIDPrompt Table: PERSON
EMPL_RCDPrompt Table: PER_ORG_ASGN_VW
ACCOMMODATION_IDDefault Value: 1
HCR_ACCOM_REQ_I(SQL View) |
Index Back |
|---|---|
Accom Requests Interface ViewAccomodation Request Inteface View. |
| SELECT A.EMPLID , A.EMPL_RCD , A.ACCOMMODATION_ID , A.DT_REQUESTED FROM PS_ACCOM_REQUEST A |
| # | 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 Rcd Nbr
Prompt Table: PER_ORG_ASGN_VW |
| 3 | ACCOMMODATION_ID |
Number(4,0) | SMALLINT NOT NULL |
Accommodation ID
Default Value: 1 |
| 4 | DT_REQUESTED | Date(10) | DATE NOT NULL | Date of Request |