BUSINESS_UNITDefault Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW
CONTRACT_TYPECA_EMAIL_TYP_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , B.CONTRACT_TYPE FROM PS_BUS_UNIT_TBL_CA A , PS_CA_TYPE_TBL B , PS_SET_CNTRL_GROUP C WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND B.SETID = C.SETID AND C.REC_GROUP_ID = 'CA_02' |
| # | 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_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 2 | CONTRACT_TYPE |
Character(15) | VARCHAR2(15) NOT NULL | Contract Type |