CAP_DET_OPEN_VW

(SQL View)
Index Back

CAP Detail


Select Business_Unit, CAP_Num, CAP_Sequence, Descr From PS_CAP_DET Where cap_status <> 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AM_NONVW

2 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #
3 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

Default Value: 1

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description