SAE_LDAP_TGT_VW(SQL View) |
Index Back |
---|---|
LDAP Target ViewLDAP Target View |
SELECT SAE_TARGET_ID ,SAE_TARGET_VERSION ,DESCR FROM %Table(SAE_TARGET_TBL) WHERE SAE_TARGET_TYPE = 'LDAP' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID | |
2 | SAE_TARGET_VERSION | Character(4) | VARCHAR2(4) NOT NULL |
Version
1.0=Version 1.0 1.5=Version 1.5 2.0=Version 2.0 2.0A=Version 2.0a |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |