SETIDMODEL_IDRG_PHS_MODL_VW(SQL View) |
Index Back |
|---|---|
Phase Model HeaderView of Phase Model Header table |
| SELECT A.SETID , A.MODEL_ID , A.DESCR , B.START_DT , B.END_DT , A.DESCRLONG FROM PS_RG_PHS_MODL_HDR A , PS_RG_PHS_MODL_USE B WHERE A.SETID = B.SETID AND A.MODEL_ID = B.MODEL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | MODEL_ID |
Character(15) | VARCHAR2(15) NOT NULL | Model Id used in Change Management Phase Models |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 5 | END_DT | Date(10) | DATE | This field stores the end date values. |
| 6 | DESCRLONG | Long Character | CLOB | Long Description |