PSARCH_IDPSARCH_BATCHNUMBUS_PROC_INSTANCEM=Main Business Project
N=Sub-Business Project
C=Complete
L=Canceled
P=In Process
F=Failure
S=Success
RC_BP_STATS_HST(SQL Table) |
Index Back |
|---|---|
Business Project StatusThe business project status record store the status for a business project. It is the highest level of a business project instance, so the instance is the only key on this record. The parent objects should have business project instance as a foreign key on their records to maintain a link. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | BUS_PROC_INSTANCE |
Number(18,0) | DECIMAL(18) NOT NULL | Business Project Instance. This is the Business Project instance of a business project. |
| 4 | RC_BUS_PROCESS_ID | Character(15) | VARCHAR2(15) NOT NULL | Business Process ID used in Business Process tracking. |
| 5 | BUS_PROJ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Business Project Type
M=Main Business Project N=Sub-Business Project |
| 6 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 7 | ID_NOTE | Character(20) | VARCHAR2(20) NOT NULL | ID Number |
| 8 | BUS_PROCESS_DATE | Date(10) | DATE | Business Project Date. This field is used to store the effective date for a specific instance of a Business Project. |
| 9 | BUS_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
This field is to store Business Process status.
C=Complete L=Canceled P=In Process |
| 10 | RC_OUTCOME | Character(1) | VARCHAR2(1) NOT NULL |
Outcome of a Task for Business Process tracking. See translates for possible values.
F=Failure S=Success |
| 11 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 12 | END_DTTM | DateTime(26) | TIMESTAMP | end date time |
| 13 | RB_DUMMY1 | Character(3) | VARCHAR2(3) NOT NULL | Multi-purpose Dummy field----- |
| 14 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 15 | RECNAME1 | Character(15) | VARCHAR2(15) NOT NULL | Record Name 1 |
| 16 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 17 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Fieldname 2 |
| 18 | RC_PORTAL | Character(254) | VARCHAR2(254) NOT NULL | Portal identification field.................... |
| 19 | RC_NODE | Character(254) | VARCHAR2(254) NOT NULL | Node identification work field........... |
| 20 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 21 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 22 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 23 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 24 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 25 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |