OPRIDFORM_TYPEA=Activated
D=In Design
I=Inactivated
EOFM_FT_SVW(SQL View) |
Index Back |
|---|---|
Fluid version Form Types |
| SELECT FORM_OWNER_ID , FORM_TYPE , FORM_TYPE_STATUS , PORTAL_NAME , PORTAL_LABEL , DESCR254 , EFFDT_FROM , EFFDT_TO FROM PS_FORM_TYPE WHERE FLUIDMODE = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | FORM_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Form and Builder Field |
| 3 | EOFM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
ePro team accidentaly changed the translate values of FORM_TYPE_STATUS field.
Created this field to workaround the issue.
A=Activated D=In Design I=Inactivated |
| 4 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 5 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | EFFDT_FROM | Date(10) | DATE | Effective Date From |
| 8 | EFFDT_TO | Date(10) | DATE | Effective Date To |