INTFC_ACT_AC_VW

(SQL View)
Index Back

Activity Search Record


SELECT INTFC_ID , INTFC_LINE_NUM , BUSINESS_UNIT , PROJECT_ID , ACTIVITY_ID FROM PS_INTFC_ACT_GEN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
2 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID