BUSINESS_UNITREQ_IDLINE_NBRSCHED_NBRCHNG_DTTMDefault Value: %DATETIME
FIELDNAMEC=Change
D=Deleted
H=Hold
I=Inserted
N=New
O=Original
R=Re-open
X=Cancelled
Default Value: C
PV_CHNG_RST_VW(SQL View) |
Index Back |
|---|---|
Change Order Request Detail |
| SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , A.SCHED_NBR , A.CHNG_DTTM , A.FIELDNAME , A.CHNG_TYPE , A.CHNG_CHAR_VALUE , A.CHNG_DATE_VALUE , A.CHNG_NBR_VALUE , A.PRIOR_CHAR_VALUE , A.PRIOR_DATE_VALUE , A.PRIOR_NBR_VALUE , A.REASON_SEQ FROM PS_PV_CHNG_RST_DTL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 5 | CHNG_DTTM |
DateTime(26) | TIMESTAMP |
Change Request Date/Time
Default Value: %DATETIME |
| 6 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | CHNG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Change Type
C=Change D=Deleted H=Hold I=Inserted N=New O=Original R=Re-open X=Cancelled Default Value: C |
| 8 | CHNG_CHAR_VALUE | Character(254) | VARCHAR2(254) NOT NULL | New Field Value |
| 9 | CHNG_DATE_VALUE | Date(10) | DATE | New Date Value |
| 10 | CHNG_NBR_VALUE | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | New Numeric Value |
| 11 | PRIOR_CHAR_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Prior Character Value |
| 12 | PRIOR_DATE_VALUE | Date(10) | DATE | Prior Date Value |
| 13 | PRIOR_NBR_VALUE | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | Prior Value |
| 14 | REASON_SEQ | Number(5,0) | INTEGER NOT NULL | Reason Sequence |