LM_FCLTY_IDLM_DUMMYFCTY_VW(SQL View) |
Index Back |
|---|---|
Dummy facility viewWe intentionally dont want this view to return any rows. It will be used for drop downs that is populated manually and we dont want ptools to fire its automatic query. |
| SELECT A.LM_FCLTY_ID , A.LM_FCLTY FROM PS_LM_FCLTY_TBL A WHERE A.LM_FCLTY_ID = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_FCLTY_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Facility ID |
| 2 | LM_FCLTY | Character(50) | VARCHAR2(50) NOT NULL | Facility Description |