GDP_TMPL_ITEM(SQL Table) |
Index Back |
|---|---|
GDP Template Items TableGuilded Process Template Items Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GDP_TEMPLATE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Guided Process Template ID |
| 2 | GDP_ACTION_ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Guided Process Action Item ID |
| 3 | GDP_SERVICEID | Character(30) | VARCHAR2(30) NOT NULL |
Guided Process Action Item Related Content Service ID
Prompt Table: GDP_SVSTYPE_VW |
| 4 | GDP_PARENT_ACTION | Character(31) | VARCHAR2(31) NOT NULL |
Guided Process Parent Action
Prompt Table: GDP_PARENT_VW |
| 5 | GDP_SEQ | Number(4,0) | SMALLINT NOT NULL | Guided Process Action Sequence |
| 6 | GDP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Guided Process Type
A=Application Class C=PS Component M=Manual N=Non PeopleSoft URL Q=PS Query S=PS Script |
| 7 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
| 8 | GDP_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Guided Process Title |
| 9 | GDP_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Guided Process Action Required
N=No Y=Yes Default Value: N |
| 10 | GDP_SUMMARY | Character(1) | VARCHAR2(1) NOT NULL |
Guided Process Summary (Parent Action)
N=No Y=Yes Default Value: N |
| 11 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 12 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |
| 13 | GDP_PREPROC_METH | Character(30) | VARCHAR2(30) NOT NULL | Guided Process Pre Process Method |
| 14 | GDP_POSTPROC_METH | Character(30) | VARCHAR2(30) NOT NULL | Guided Process Post Process Method |
| 15 | GDP_ITEM_QUESTION | Character(150) | VARCHAR2(150) NOT NULL | Guided Process Action Item Question |
| 16 | GDP_QUEST_DETAIL | Long Character | CLOB | Guided Process More Question Detail |
| 17 | GDP_ACTN_FLD1 | Character(100) | VARCHAR2(100) NOT NULL | Guided Process Action Item Data Field 1 |
| 18 | GDP_ACTN_FLD2 | Character(100) | VARCHAR2(100) NOT NULL | Guided Process Action Item Data Field 2 |
| 19 | GDP_ACTN_FLD3 | Character(100) | VARCHAR2(100) NOT NULL | Guided Process Action Item Data Field 3 |
| 20 | GDP_ACTN_FLD4 | Character(100) | VARCHAR2(100) NOT NULL | Guided Process Action Item Data Field 4 |
| 21 | GDP_ACTN_FLD5 | Character(100) | VARCHAR2(100) NOT NULL | Guided Process Action Item Data Field 5 |
| 22 | GDP_ACTN_FLD6 | Character(1) | VARCHAR2(1) NOT NULL | Guided Process Action Item Y/N Field 1 |
| 23 | GDP_ACTN_FLD7 | Character(1) | VARCHAR2(1) NOT NULL | Guided Process Action Item Y/N Field 2 |
| 24 | GDP_ACTN_FLD8 | Character(1) | VARCHAR2(1) NOT NULL | Guided Process Action Item Y/N Field 3 |
| 25 | GDP_ACTN_FLD9 | Character(1) | VARCHAR2(1) NOT NULL | Guided Process Action Item Y/N Field 4 |
| 26 | GDP_ACTN_FLD10 | Character(1) | VARCHAR2(1) NOT NULL | Guided Process Action Item Y/N Field 5 |
| 27 | GDP_PAGE_RICH_TEXT | Long Character | CLOB | Page Text |
| 28 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |