[Home] [Help] [Dependency Information]
Object Name: | LM_SPRD_PRM |
---|---|
Object Type: | TABLE |
Owner: | GMD |
FND Design Data: | GMD.LM_SPRD_PRM |
Subobject Name: | |
Status: | VALID |
Table used to store the technical paramter definitions that belong with the spreadsheet
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SPRD_ID | NUMBER | (10) | Yes | Surrogate id for spreadsheet |
LAB_TYPE | VARCHAR2 | (4) | Lab type for which the spreadsheet was created | |
TECH_PARM_NAME | VARCHAR2 | (8) | Yes | Technical parameter name from lm_tech_prm |
SORT_SEQ | NUMBER | (5) | Yes | Sort sequence for parameter on the spreadsheet |
QC_ORGN_CODE | VARCHAR2 | (4) | Orgnanization code under which the QC assay was created IF the tech parameter is a QC assay, or null if not | |
QC_ASSAY_NAME | VARCHAR2 | (16) | Name of QC assay IF the tech parameter is a QC assay, or null if not | |
DATA_TYPE | NUMBER | (5) | The data type of the technical parameter. 0=Character, 1=Numeric, 2=Validation List, 3=Boolean, 4=Expression, 5=Weight Percent, 6=Volume Percent, 7=Specific Gravity, 8=Cost, 9=Equivalent Weight, 10=Quantity per Unit. | |
EXPRESSION_CHAR | VARCHAR2 | (160) | The expression used to calculate the technical parameter, for data type 4 (Expression). | |
LM_UNIT_CODE | VARCHAR2 | (4) | The unit of measure in which the technical parameter value is expressed. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
ORGN_CODE | VARCHAR2 | (4) | Organization Code | |
TECH_PARM_ID | NUMBER | (15) | The technical parameter surrogate key | |
MAX_VALUE | NUMBER | Parameter maximun value has to be saved to simulator | ||
OPTIMIZE_TYPE | NUMBER | (5) | Optimize type is used in save simulation | |
PRECISION | NUMBER | Parameter precision has to be saved to simulator | ||
MIN_VALUE | NUMBER | Parameter minimum value has to be saved in simulator | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | This is the column to identify the organization for parameters |
Cut, paste (and edit) the following text to query this object:
SELECT SPRD_ID
, LAB_TYPE
, TECH_PARM_NAME
, SORT_SEQ
, QC_ORGN_CODE
, QC_ASSAY_NAME
, DATA_TYPE
, EXPRESSION_CHAR
, LM_UNIT_CODE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, ORGN_CODE
, TECH_PARM_ID
, MAX_VALUE
, OPTIMIZE_TYPE
, PRECISION
, MIN_VALUE
, ORGANIZATION_ID
FROM GMD.LM_SPRD_PRM;
GMD.LM_SPRD_PRM does not reference any database object
GMD.LM_SPRD_PRM is referenced by following:
|
|
|