RECNAMEPrompt Table: PSRCFLD_VW
Prompt Table: PSFIELD_VW
Y/N Table Edit
Default Value: N
Prompt Table: MESSAGE_SET_VW
Prompt Table: PSMSGCATDEFN
ID_DEL_PRVN_TBL(SQL Table) |
Index Back |
|---|---|
Setup Tbl - ID Delete ProcThis is a setup table for the user to indicate the records to look into for the presence of data during the ID Delete Process. If data is found in a table which is contained in this setup table, then the delete process will stop. The code for the ID delete process is executed in PERSONAL.DATA.EMPLID @ ROWINIT if the panel is EMPLOYEE_ID_DELETE. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRCFLD_VW |
| 2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSFIELD_VW |
| 3 | REQD_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Required Indicator
Y/N Table Edit Default Value: N |
| 4 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: MESSAGE_SET_VW |
| 5 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN |