TD_CLAIM_AUT_VW

(SQL View)
Index Back

Auto Number Prompt View

Auto Number Prompt View for claim id

SELECT A.SETID , A.BEG_SEQ , A.DESCR , A.MAX_LENGTH , A.LAST_AUTO_NBR FROM PS_AUTO_NUM_TBL A WHERE A.NUM_TYPE='CLM'

  • Related Language Record: TD_CLAIMAUT_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BEG_SEQ Character(3) VARCHAR2(3) NOT NULL Beginning Sequence
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 MAX_LENGTH Number(2,0) SMALLINT NOT NULL Maximum Length of Auto Number
    5 LAST_AUTO_NBR Number(18,0) DECIMAL(18) NOT NULL Last Auto-Assigned Number