SETIDPrompt Table: SP_SETID_NONVW
FIELDNAMEPrompt Table: PSDBFLD_LENGTH
RQ_AUTONMFLD_VW(SQL View) |
Index Back |
|---|---|
Quality Auto Numbering ViewQuality application numbering view |
| SELECT A.SETID , A.FIELDNAME , B.NUM_TYPE , B.DEFAULT_BEG_SEQ , B.MAX_LENGTH FROM PS_AUTO_NUMFLD_TBL A , PS_AUTO_NUM_TBL B WHERE A.SETID = B.SETID AND A.NUM_TYPE = B.NUM_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSDBFLD_LENGTH |
| 3 | NUM_TYPE | Character(4) | VARCHAR2(4) NOT NULL | This field is used for auto numbering. |
| 4 | DEFAULT_BEG_SEQ | Character(1) | VARCHAR2(1) NOT NULL | Default Auto Number |
| 5 | MAX_LENGTH | Number(2,0) | SMALLINT NOT NULL | Maximum Length of Auto Number |