PC_PRJ_UFLD_TVW

(SQL View)
 Index Back

Proj/Activity User Field Setup

Proj/Activity User Field Label Setup

SELECT 'U1','PROJECT_USER1','FIELD1','ACTIVITY_USER1','ACTIVITY_FIELD1' FROM PS_INSTALLATION UNION SELECT 'U2','PROJECT_USER2','FIELD2','ACTIVITY_USER2','ACTIVITY_FIELD2' FROM PS_INSTALLATION UNION SELECT 'U3','PROJECT_USER3','FIELD3','ACTIVITY_USER3','ACTIVITY_FIELD3' FROM PS_INSTALLATION UNION SELECT 'U4','PROJECT_USER4','FIELD4','ACTIVITY_USER4','ACTIVITY_FIELD4' FROM PS_INSTALLATION UNION SELECT 'U5','PROJECT_USER5','FIELD5','ACTIVITY_USER5','ACTIVITY_FIELD5' FROM PS_INSTALLATION UNION SELECT 'U6','PC_USER_CURRENCY','PC_USER_CURRENCY','PC_USER_CURRENCY','PC_USER_CURRENCY' FROM PS_INSTALLATION UNION SELECT 'U7','PROJECT_USERAMT1','PROJECT_USERAMT1','PC_ACT_USERAMT1','PC_ACT_USERAMT1' FROM PS_INSTALLATION UNION SELECT 'U8','PROJECT_USERAMT2','PROJECT_USERAMT2','PC_ACT_USERAMT2','PC_ACT_USERAMT2' FROM PS_INSTALLATION UNION SELECT 'U9','PROJECT_USERAMT3','PROJECT_USERAMT3','PC_ACT_USERAMT3','PC_ACT_USERAMT3' FROM PS_INSTALLATION UNION SELECT 'U91','PROJECT_USER_DT1','PROJECT_USER_DT1','PC_ACT_USER_DT1','PC_ACT_USER_DT1' FROM PS_INSTALLATION UNION SELECT 'U92','PROJECT_USER_DT2','PROJECT_USER_DT2','PC_ACT_USER_DT2','PC_ACT_USER_DT2' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRJ_USER_FIELD Character(3) VARCHAR2(3) NOT NULL Missing User Fields
U1=User Field 1
U2=User Field 2
U3=User Field 3
U4=User Field 4
U5=User Field 5
U6=User Currency
U7=User Amount 1
U8=User Amount 2
U9=User Amount 3
U91=User Date 1
U92=User Date 2
2 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
3 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
4 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2
5 LABEL18 Character(18) VARCHAR2(18) NOT NULL Label