P 2 K_FC_ASSUMPTION_STATEMENTS

Alias: FASS#

(P2K_FC_ASSUMPTION_STATEMENTS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-FC01


Assumption Statements

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
STATEMENT_CODEVarchar2(16)CODEY
STATEMENT_STATUSVarchar2(2)X_STATEMENT_STATUSY
STATEMENT_GROUPVarchar2(2)X_STATEMENT_GROUPY
ASSUMPTION_SEQUENCENumber(5)NUMBER5Y
ASSUMPTION_TYPEVarchar2(2)X_ASSUMPTION_TYPEY
ASSUMPTION_ACTIONVarchar2(2)X_ASSUMPTION_ACTIONY
START_DATEDate()DATE
END_DATEDate()DATE
DESCRIPTIONVarchar2(50)DESCRIPTION
ASSUMPTION_FORMULAVarchar2(2000)VARCHAR2000
ASSUMPTION_WHEREVarchar2(2000)VARCHAR2000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page