QA_SAMPLE_STD_RULE
Seeded entity to determine sample size and associated acceptance and rejection number for a lot against Acceptance Quality Limits (AQL) defined as per ANSI/ASQ standards.
Details
-
Schema: FUSION
-
Object owner: QA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
QA_SAMPLE_STD_RULE_PK |
RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RULE_ID | NUMBER | 18 | Yes | Unique identifier for sample standard rule. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| SAMPLING_STD_CODE | VARCHAR2 | 30 | Yes | Indicates type of sampling plan used for the inspection. | |
| SAMPLE_SIZE_CODE | VARCHAR2 | 3 | Yes | Sample size code letter for an inspection level. | |
| SAMPLE_SIZE | NUMBER | Yes | Sample size for the sampling standard and sample size code. | ||
| ACCEPTANCE_QUALITY_LIMIT | NUMBER | Yes | Acceptance quality limit used to determine the sampling plan. | ||
| ACCEPTANCE_NUMBER | NUMBER | Acceptance Number associated with the sampling plan. | |||
| REJECTION_NUMBER | NUMBER | Rejection Number associated with the sampling plan. | |||
| SAMPLING_SEQUENCE | NUMBER | Yes | Sampling sequence within single, Double or Multiple sampling plans. Value is 1 for all single sampling plans. | ||
| CUMULATIVE_SAMPLING_SIZE | NUMBER | Cumulative sample size. Applicable for double or multiple sampling plans. | |||
| ANSI_ASQ_STANDARD | VARCHAR2 | 30 | Yes | ANSI/ASQ standard such as ANSI-ASQ Z1.4-2003 (2018). | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QA_SAMPLE_STD_RULE_U1 | Unique | FUSION_TS_SEED | RULE_ID, ORA_SEED_SET1 |
| QA_SAMPLE_STD_RULE_U11 | Unique | FUSION_TS_SEED | RULE_ID, ORA_SEED_SET2 |
| QA_SAMPLE_STD_RULE_U2 | Unique | FUSION_TS_SEED | SAMPLING_STD_CODE, SAMPLE_SIZE_CODE, ACCEPTANCE_QUALITY_LIMIT, SAMPLING_SEQUENCE, ANSI_ASQ_STANDARD, ORA_SEED_SET1 |
| QA_SAMPLE_STD_RULE_U21 | Unique | FUSION_TS_SEED | SAMPLING_STD_CODE, SAMPLE_SIZE_CODE, ACCEPTANCE_QUALITY_LIMIT, SAMPLING_SEQUENCE, ANSI_ASQ_STANDARD, ORA_SEED_SET2 |