SCC_FIELDSVW(SQL View) |
Index Back |
---|---|
fields prompt |
SELECT scc_page , fieldname , descr FROM PS_SCC_FIELD_SETUP WHERE scc_display = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_PAGE | Character(4) | VARCHAR2(4) NOT NULL |
Page
CONS=Submission Fields LAU=Task Launch OTRQ=Other Assignment Fields SUPR=Supervisor Fields THES=Thesis Fields TOP=Research Topic Self service TOPC=Topic Fields |
2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |