PROJ_HOME_FAQ(SQL Table) |
Index Back |
|---|---|
Frequently Asked QuestionsFrequently Asked Questions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DOCUMENT_REQUESTS |
Number(7,0) | INTEGER NOT NULL | Number of Requests |
| 2 | FAQ_ID |
Character(30) | VARCHAR2(30) NOT NULL | Frequently Asked Question |
| 3 | DOCUMENT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Document Type
123=Lotus 1-2-3 AVI=Video for Windows CAD=AutoCad Document DOC=Microsoft Winword MPP=MicroSoft Project NON=No Document Type PST=PeopleSoft PeopleTools SCR=Lotus ScreenCam TLP=TimeLine for Windows TXT=Notepad for ASCII Text XLS=Microsoft Excel Default Value: SCR |
| 4 | DOCUMENT_DRIVE | Character(5) | VARCHAR2(5) NOT NULL | Document Drive |
| 5 | DOCUMENT_PATH | Character(80) | VARCHAR2(80) NOT NULL | Application Path |
| 6 | DOCUMENT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Document Path and Name |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |