MILESTONE_CAF

(SQL Table)
Index Back

Milestone CAF Table

Milestone CAF Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 MILESTONE Character(10) VARCHAR2(10) NOT NULL Milestone
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 SCC_CAF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Attribute Sequence
5 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute

Prompt Table: %EDITTABLE18

6 SCC_CAF_ATTR_VAL Character(20) VARCHAR2(20) NOT NULL Attribute Value
7 SCC_CAF_ATTR_NVAL Number(32,11) DECIMAL(31,11) NOT NULL Numeric Value
8 SCC_CAF_ATTR_DVAL Date(10) DATE Date Value
9 SCC_CAF_ATTR_TVAL Character(50) VARCHAR2(50) NOT NULL Text Value
10 SCC_CAF_ATTR_TIME Time(15) TIMESTAMP Time Value
11 SCC_CAF_ATTR_YNO Character(1) VARCHAR2(1) NOT NULL Yes/No Value

Y/N Table Edit

12 SCC_CAF_ATTR_LVAL Long Character CLOB Long Text Value