IMP_ORG_PFL_TL

(SQL Table)
Index Back

CDH PS_IMP_ORG_PROFILE_EXT_TL

CDH INTERFACE TABLE - PS_IMP_ORG_PROFILE_EXT_TL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BATCH_ID Number(15,0) DECIMAL(15) NOT NULL CDH INTERFACE TABLE FIELD - BATCH_ID
3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
4 PARTY_ORIG_SYSTEM Character(30) VARCHAR2(30) NOT NULL CDH INTERFACE TABLE FIELD - PARTY_ORIG_SYSTEM
5 EXTENSION_ID Number(15,0) DECIMAL(15) NOT NULL CDH INTERFACE TABLE FIELD - EXTENSION_ID
6 ORG_PROFILE_ID Number(15,0) DECIMAL(15) NOT NULL CDH INTERFACE TABLE FIELD - ORGANIZATION_PROFILE_ID
7 ATTR_GROUP_NBR Number(15,0) DECIMAL(15) NOT NULL CDH INTERFACE TABLE FIELD - ATTR_GROUP_NBR
8 FLEX_CONTEXT_CODE Character(30) VARCHAR2(30) NOT NULL CDH INTERFACE TABLE FIELD - DESCRIPTIVE_FLEX_CONTEXT_CODE
9 EFFDT Date(10) DATE Effective Date

Default Value: %date

10 KEY1 Character(65) VARCHAR2(65) NOT NULL First Key
11 KEY2 Character(65) VARCHAR2(65) NOT NULL Second Key
12 SOURCE_LANG Character(4) VARCHAR2(4) NOT NULL CDH INTERFACE TABLE FIELD - SOURCE_LANG
13 LANGUAGE Character(15) VARCHAR2(15) NOT NULL Language
14 CDH_CREATED_BY Number(15,0) DECIMAL(15) NOT NULL CDH INTERFACE TABLE FIELD - CDH_CREATED_BY
15 CREATION_DATE Date(10) DATE Creation date of the case.
16 LAST_UPDATED_BY Number(15,0) DECIMAL(15) NOT NULL CDH INTERFACE TABLE FIELD - LAST_UPDATED_BY
17 LAST_UPDATE_DATE Date(10) DATE Last Update Date
18 LAST_UPDATE_LOGIN Number(15,0) DECIMAL(15) NOT NULL CDH INTERFACE TABLE FIELD - LAST_UPDATE_LOGIN