FS_ACTIVITY_TBL(SQL Table) |
Index Back |
---|---|
Central Activty SetupCentral activity setup table. To be used by PC, PF and all other apllication that need activities. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | PROJECT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Project Type
A=Activity G=Grant H=Phase P=Project S=Segment Prompt Table: PROJ_TYPE_TBL |
5 | ACT_USE_PC | Character(1) | VARCHAR2(1) NOT NULL |
Projects
Y/N Table Edit Default Value: Y |
6 | ACT_USE_PF | Character(1) | VARCHAR2(1) NOT NULL |
Performance Measurement
Y/N Table Edit Default Value: N |
7 | ACT_USE_SP | Character(1) | VARCHAR2(1) NOT NULL |
Services Procurement field
Default Value: N |