HCI_ACCOMOPT_VW(SQL View) |
Index Back |
|---|---|
View of Accommodation OptionView of accommodation option used by Campus Integration. |
| SELECT EMPLID ,EMPL_RCD ,ACCOMMODATION_ID ,ACCOMMODATION_OPT ,ACCOMMODATION_TYPE ,CURRENCY_CD ,ACCOM_COST ,EMPLOYER_SUGGESTED ,ACCOM_STATUS ,STATUS_DT FROM PS_ACCOM_OPTION |
| # | 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 | ACCOMMODATION_OPT |
Number(3,0) | SMALLINT NOT NULL | Accommodation Options |
| 5 | ACCOMMODATION_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Accommodation Type
Prompt Table: ACCOM_TYPE_TBL |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 7 | ACCOM_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Cost of Accommodation |
| 8 | EMPLOYER_SUGGESTED | Character(1) | VARCHAR2(1) NOT NULL |
Employer Suggested Option
Y/N Table Edit Default Value: N |
| 9 | ACCOM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Accommodation Status
A=Approved C=Consider O=Offered P=Accepted R=Rejected U=Undue Hardship Default Value: C |
| 10 | STATUS_DT | Date(10) | DATE NOT NULL |
Status Date
Default Value: ACCOM_REQUEST.DT_REQUESTED |