MU_SECTIONMU_ELEMENTMU_SECTION_PREPrompt Table: MU_TP_SETUP_TBL
MU_ELEMENT_PREPrompt Table: MU_TP_PRE_VW
Prompt Table: PSDBFIELDNAMEVW
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
MU_TP_SETUP_PRE(SQL Table) |
Index Back |
|---|---|
TP PrerequisitesDefines relationships between elements available for a change. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MU_SECTION |
Character(20) | VARCHAR2(20) NOT NULL | Section |
| 2 | MU_ELEMENT |
Character(20) | VARCHAR2(20) NOT NULL | Element |
| 3 | MU_SECTION_PRE |
Character(20) | VARCHAR2(20) NOT NULL |
Section Prerequisite
Prompt Table: MU_TP_SETUP_TBL |
| 4 | MU_ELEMENT_PRE |
Character(20) | VARCHAR2(20) NOT NULL |
Element Prerequisite
Prompt Table: MU_TP_PRE_VW |
| 5 | MU_PROMPT_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Prompt Field
Prompt Table: PSDBFIELDNAMEVW |
| 6 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |