STDNT_TEST2_MC(SQL Table) |
Index Back |
---|---|
Student Test2 Components MCUse STDNT_TEST_COMP to enter scores by test component for tests taken by a student. A Composite test component can be identified so that a score for the entire test can be entered, if appropriate. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | MC_DEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Mass Change Definition |
2 | MC_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Mass Change Status
APR=Approved Transaction CAN=Cancel Transaction ERR=Errored Transaction PND=Pending Transaction SCS=Successful Transaction |
3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
5 | SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Test Score |