SCC_ENTITY_IDSCC_APPCLASSNAMEPrompt Table: SCC_APPCLASS_PT
A=Active
I=Inactive
10=Save
20=Validate
30=Fill
40=Promote
50=Demote
60=Delete
70=Other
10=Passed
20=Failed
SCC_ENTITY_UT(SQL Table) |
Index Back |
|---|---|
Entity Unit TestEntity Unit Test |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_ENTITY_ID |
Character(40) | VARCHAR2(40) NOT NULL | Entitiy ID |
| 2 | SCC_APPCLASSNAME |
Character(190) | VARCHAR2(190) NOT NULL |
Used to represent an application class as a single string. Usually
RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)
Prompt Table: SCC_APPCLASS_PT |
| 3 | SCC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Status
A=Active I=Inactive |
| 4 | SCC_ENTITY_UT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Type
10=Save 20=Validate 30=Fill 40=Promote 50=Demote 60=Delete 70=Other |
| 5 | SCC_LASTRUN_STS | Character(2) | VARCHAR2(2) NOT NULL |
Last Run Status
10=Passed 20=Failed |
| 6 | SCC_LASTRUN_DTTM | DateTime(26) | TIMESTAMP | Last Run Datetime |
| 7 | SCC_ENT_LRUN_DTL | Long Character | CLOB | Lastrun Details |