DP_CAPDESC_AET(SQL Table) |
Index Back |
---|---|
State Record for DH Ae |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
5 | DP_CONFIGVIEW | Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW |
6 | DP_CONFIGLEVEL | Number(2,0) | SMALLINT NOT NULL | DP_CONFIGLEVEL |
7 | DP_BUILDCAPDESC | Character(1) | VARCHAR2(1) NOT NULL |
DP_BUILDCAPDESC
B=Build Caption and Description C=Build Caption Only D=Build Description Only |
8 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
9 | DP_KEYFLDNAMES | Character(254) | VARCHAR2(254) NOT NULL | DP_KEYFLDNAMES |