ADM_T130_PAD_VW(SQL View) |
Index Back |
---|---|
TS130 Address ViewADM_T130_PAD_VW displays all of the name types which have address associated with them for a person. |
SELECT DISTINCT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.TRANS_CNTRL_NBR , A.SEQNUM , A.EDI_NAME_TYPE , A.TRANS_ROW_ID FROM PS_ADM_T130_PER_EC A , PS_ADM_T130_ADR_EC B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND A.TRANS_CNTRL_NBR = B.TRANS_CNTRL_NBR AND A.SEQNUM = B.SEQNUM |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) | |
2 | Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. | |
3 | Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound |
|
4 | Character(9) | VARCHAR2(9) NOT NULL | Transaction Set Control Number | |
5 | Number(3,0) | SMALLINT NOT NULL | Sequence Number | |
6 | EDI_NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
EDI Name Type
01=Given Name (Name at Birth) 02=Current Legal 03=Alias 04=Name of Record 05=Previous Name 07=Married Name 08=Professional Name |
7 | TRANS_ROW_ID | Character(3) | VARCHAR2(3) NOT NULL | Transaction Row ID |