GDP_TEMPLATE_IDGDP_MBR_TYPEROLE=Role
USER=User
Default Value: ROLE
GDP_MBR_NAMEPrompt Table: %EDITTABLE
Prompt Table: PTAI_PRIVSETVW
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
GDP_TMPL_PRIV(SQL Table) |
Index Back |
|---|---|
GDP Template Privileges TableGuided Process Template Priviliges 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_MBR_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Guided Process Member Type
ROLE=Role USER=User Default Value: ROLE |
| 3 | GDP_MBR_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
Guided Process Member Name (Role)
Prompt Table: %EDITTABLE |
| 4 | GDP_PRIVSET_ID | Character(30) | VARCHAR2(30) NOT NULL |
Guided Process Privilege Set Id
Prompt Table: PTAI_PRIVSETVW |
| 5 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |