MC_TYPE_IDMC_STMNT_SEQMC_SEQPrompt Table: MC_RECNAME_VW
B=Sub Select
D=Delete
I=Insert
M=Select Sum
S=Select
T=Select Distinct
U=Update
MC_TYPE_RECORD |
index back |
|---|---|
Mass Change Type Record |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| MC_TYPE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Mass Change Type ID |
| MC_STMNT_SEQ |
Number(3,0) | SMALLINT NOT NULL | Mass Change Statement Sequence |
| MC_SEQ |
Number(3,0) | SMALLINT NOT NULL | Mass Change Sequence |
| RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: MC_RECNAME_VW |
| MC_RECORD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
SQL Action
B=Sub Select D=Delete I=Insert M=Select Sum S=Select T=Select Distinct U=Update |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |